Ricardo Andere de Mello <gandhi <at> quilombodigital.org> writes:
> > The same happens to me with 3500 messages. > I really think this is related to caching in squirrelmail, but I didn't > look at the code, so I can not confirm this. > > []s, gandhi > > Richard Houston wrote: > > >Hi all, > > > >I have a brand new dbmail 2.0 RC8 install using Fedora Core 2 and Mysql > >4.0.20. > > > >Everything seems to work very well. I have been able to copy from one imap > >account to the dbmail server with great performance. I am a long time > >Cyrus user so speed is something I keep my eye on. > > > >I have found one small issue. If I check the mail via Squirrelmail 1.4.3A > >and open a folder with 1300 messages in it The hard disk thrashes like mad > >and it take over 30 seconds to get the message list. This is done with > >pagination turned on. once I have the folder open the pages with message > >21 TO 40 open quickly and on down the line..... > > > >I was wondering if I need to set anything on the sqmail side, tune mysql > >or anything? > > > >Any help would be greatly appreciated. > > > >Regards, > >+------------------------------------------+ > >| Richard Houston .^. | > >| R.L.H. Consulting /V\ | > >| E-Mail <rhouston <at> rlhc.net> /( )\ | > >| WWW <www.rlhc.net> ^^-^^ | > >+------------------------------------------+ > > > > > >_______________________________________________ > >Dbmail mailing list > >Dbmail <at> dbmail.org > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > Richard, The slowness that you are experiencing is with Squirrelmail. Squirrelmail 1.4.3a reads all the headers of the entire pieces of email you have in your INBOX via IMAP. So if you have 2K or 100K of messages, this will take forever and you might even get a PHP timeout. IMAP is the real bottleneck in Squirrelmail. SM is okay if you keep your email in your INBOX to about less than 300 emails. If you went on a vacation and your INBOX has 1K messages in it when you return, hehehe you will need to wait for a while to get your emails. SM 1.5.1 seems to ONLY read the needed headers to be diplayed in one index page. It is not a release version yet but seems to work a bit better than SM 1.4.3a. If somebody can write a plugin or modify or patch squirrelmail to access DBMAIL directly without using IMAP, this will be the holy grail. Even the search feature in SM will then be super fast. Robert
