Bokhan Artem wrote: > Paul, what for dbmail executes this query with imap "select Inbox"?
It retrieves the meta data for all messages in the mailbox involved. > That's headshot for large mailboxes. It shouldn't be that hard on the database. How big is that mailbox? > > SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, > recent_flag, DATE_FORMAT(internal_date, GET_FORMAT(DATETIME,'ISO')), > rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm > WHERE pm.id = msg.physmessage_id AND mailbox_idnr = 1 AND status IN > (0,1) ORDER BY message_idnr ASC > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
