Another thing to keep in mind is that the size of the messageblks table is going to make a diffence in how IMAP performs. If you have a ton of messages in the database it might be a little bit slow. But with the hardware that you are running you should be ok. I have a Dual P!!! 866 with 2 GB of RAM and 1.5 GB of messages and with the all the indexing it is fast as heck.
Bret. On Thursday 15 August 2002 01:12 pm, Sam Przyswa wrote: > Bret Baptist ([EMAIL PROTECTED]) écrivait: > >I tried the MySQL indexing that is show here > >https://mailman.fastxs.nl/pipermail/dbmail/2002-April/000435.html. > > The link it's not working for me, can you give the exact modification to do > in the indexing. > > I noticed the same thing with dbmail-imapd and a PHP Webmail, but not with > Outlook, Netscape, Mozila. > > We have MySQL+InnoDB with a messageblks about 4.8Gb size on bi-proc 1.3Ghz > pentium machine with 512Mb memory and UW-SCSI RAID 15Gb disk, there is a > log of an IMAP request: <--snip logs--> > > It take 9 Sec to fetch 15 messages within a mailbox of about 40 messages. > > I got best results with Courier-IMAP... > > Sam. -- Bret Baptist Systems and Technical Support Specialist [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 x17 Web Development-Web Marketing-ISP Services ------------------------------------------ Today is the tomorrow you worried about yesterday.