Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted July 15, 200519 yr This isn't really a bug, but I think it isn't the best approach to keep a separate count of the number of rows in the mail_queue table in the systemvars cache. Seems to me that there is a potential for the count in the cache to not reflect the actual count in the table (resulting in mail in the queue not being serviced in a timely manner). Why go to all this trouble? Doing "select count(*) as count from ibf_mail_queue" is a query that is about as fast as you can get. MySQL doesn't even have to scan the table to count the rows as this count is maintained in the system tables for the database. Anyway, it is a small thing, but I think you should remove using this extra variable and just query the count directly. Seems simpler to me. Maybe I'm missing something about why this was done in the first place?
July 15, 200519 yr i think the new mail_queue feature is not finishedhttp://www.invisionboard.com/?ipb21roadmap Ability to "hold" an item in the mail queue for later processing <-- in black
Archived
This topic is now archived and is closed to further replies.