Hi, I've been working on another project that has huge tables that need to be searched, (1-3GB) and on my searches I could initially cut the table down to a smaller piece by using a temporary table, and then applying the remainder search patterns to this. This resulted in HUGE speedups of the search.
This got me thinking about the DBMail IMAP implimentation. I wonder if it would make sense to initially create a temp table upon login that contains only that user's mailboxes, then during that sesssion all sorting/searching etc would work from that temp table. I bet it would really speed things up but at the expense of an additional bit of time right at login. This is all experience from a MySQL point of view, don't know about pgsql/oracle on this, but I think temp tables are pretty standard in SQL. -Micah
