Thanks a lot, I have added the new indexes as follow and this speed the IMAP response.
Sam. Bret Baptist ([EMAIL PROTECTED]) écrivait: > >Wierd link works perfect for me. Ohh well. Waste of bandwidth follows: > > >CREATE TABLE messages ( > message_idnr bigint(21) NOT NULL auto_increment, > mailbox_idnr bigint(21) NOT NULL default '0', > messagesize bigint(21) NOT NULL default '0', > rfcsize bigint(21) NOT NULL default '0', > seen_flag tinyint(1) NOT NULL default '0', > answered_flag tinyint(1) NOT NULL default '0', > deleted_flag tinyint(1) NOT NULL default '0', > flagged_flag tinyint(1) NOT NULL default '0', > recent_flag tinyint(1) NOT NULL default '0', > draft_flag tinyint(1) NOT NULL default '0', > unique_id varchar(70) NOT NULL default '', > internal_date datetime NOT NULL default '0000-00-00 00:00:00', > status tinyint(3) unsigned zerofill NOT NULL default '000', > PRIMARY KEY (message_idnr), > KEY idx_mailbox_idnr (mailbox_idnr,status,unique_id,seen_flag), > KEY idx_status (status), > KEY idx_unique_id (unique_id), > KEY idx_expunge (mailbox_idnr,deleted_flag,status), > KEY idx_flag (message_idnr,unique_id,mailbox_idnr,status), > KEY idx_answered_flag (mailbox_idnr,status,unique_id,answered_flag), > KEY idx_deleted_flag (mailbox_idnr,status,unique_id,deleted_flag), > KEY idx_flagged_flag (mailbox_idnr,status,unique_id,flagged_flag), > KEY idx_recent_flag (mailbox_idnr,status,unique_id,recent_flag), > KEY idx_draft_flag (mailbox_idnr,status,unique_id,draft_flag) >) TYPE=MyISAM; -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]
