The design scheme of the letter in the sending station

With the increase of registered users, the previous old Send station letter function is not suitable for use (need to send a long time), how do you solve this problem?
Crontab Server background Timer?
How is it implemented?

Reply content:

With the increase of registered users, the previous old Send station letter function is not suitable for use (need to send a long time), how do you solve this problem?
Crontab Server background Timer?
How is it implemented?

Have to look at the existing station inside the letter procedure have what problem, why take a long time? Did you use APM to monitor performance? Are there any performance indicators? There is no specific data, there is no specific optimization plan.

Where you are time consuming. We split the private messages table by 20 minutes, directly with SQL or quickly.

Attention table, Fan table, the station letter similar to the single table more than 100w proposed sub-table, the table name user_id to take surplus.

Landlord problems need to track the sending station letter time card where, that is, the system bottleneck.

