Jump to content

mail_queue and systemvars cache

Guest K. T. Walrus

Recommended Posts

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?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...