Re: [RCD] slow messages deleting - read_when_deleted being a performance killer

darklight wrote:

let's try to explain so many database queries (NOTE: keep in mind I had read_when_deleted enabled): when user deletes message 1 from mailbox X the following happens:

• $IMAP->set_flag($uids, 'SEEN'); reads and deletes all messages from

the caching table... that already makes 400 queries

• (message being moved through IMAP)
• (message being parsed through IMAP)
• message being inserted into the cache table (in the DB) again - that

makes another 200 queries -> we're at a total of 600 now

So, it kills performance only when caching is enabled. Did you test with current svn-trunk? There were some changes lately. I'll investigate this a little bit.