Sean Chittenden wrote:
Is this what's causing the gazillion SELECT queries for each message
upload?
The many queries after uploads (in your case) come from a combination of two
known bugs:
recent flag always set:
http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000097
imap search performance:
http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000149
Esp. the latter one makes for too many queries. The first one was fixed in cvs-head, and I'll (hopefully) fix
the latter one in cvs-head during the next week. After those two are fixed the number of queries for commands
like:
04 UID SEARCH RECENT HEADER MESSAGE-ID <[EMAIL PROTECTED]>
will be limited to RECENT messages only, and not - as is now the case - require parsing of bloody well *all*
messages in the mailbox, irrespective of there recent status. For more info look to the info posted with #149
Hell, after I implement the header caching system I've outlined in the wiki last week, these search commands
will become dirt cheap, and *very* fast indeed. I've already begun working my way up the insertion chain with
my unit-testing testsuite, reworking the call involved to use gmime/glib. As that work progresses, we'll get
X-DBMAIL-ID headers, and full header caching to wit.
So bear with me. This will be remedied.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
