Quote:
Originally Posted by mprjr41510
SilverBoy,
Yes, that is a good idea... Similar to the way you can email users through vBulletin. It let's you choose a certain number of messages to send so you can do it in batches.
Hey uae, is this something you can add to the hack? 
|
PMs are a lot different then email in that they are inserted into the database, they are not sent out, you may be right however that by doing a certain amount at one time may help, but I don't think so.
I got thinking about this, and you could be right, especially if you sent it to 36000 people. I haven't done much with database optimization, but that may be what you want to look at. I was reading that you could 'lock' the table and insert multiple records at once, which may be what you want to do, that is, eliminating that many insert statements could help. I don't know for sure however.