Paul J Stevens wrote: > > So, how are you trying to move messages? Not that it will speed up > SEARCH, but we might be able to solve your bottleneck problem. >
I believe that this is a defect in the implementation of Apple's Mail program. I have tried dragging and dropping messages from one folder to another and it does something to cause DBMail to execute these queries. Also, when using mail filters in Apple Mail it does the same thing. I don't know if other IMAP implementations don't need to do this but we still have a severe performance issue in DBMail when it takes over a second to find a message. Paul J Stevens wrote: > > The relevant quote form the RFC: > > 6.4.4. SEARCH Command > .... > In all search keys that use strings, a message matches the key if > the string is a substring of the field. The matching is > case-insensitive. > .... > Ok, ok, I definitely believe you. :) I am just now in a position where I don't know how to make this search any faster. I'll have to dig in the PostgreSQL docs deeper or deal with the fact that I'm going to modify the DBMail source and make my own system non-compliant. I'm not excited about making a change that's against the RFC but for a performance increase of two orders of magnitude I'd be willing to try it. I've been trying to move 7000 messages now for an entire day and it just never quite finishes. I also have noticed removal of duplicate messages by Thunderbird never finishes either. I have run it several times and it finds lots of dupes but can never manage to remove them. It has been driving me crazy for months. Maybe that could be related too? Tim -- View this message in context: http://old.nabble.com/Performance-issue-when-copying-moving-messages-in-PostgreSQL-%28IMAP%29-tp26849342p26859985.html Sent from the dbmail dev mailing list archive at Nabble.com. _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
