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

Hi,

Please test also r2674. I see there's at least one place for improvement. When message is added to cache then SELECT and INSERT/UPDATE are executed. I think there're situations when we could skip SELECT query. This should speed up messages and messages list displaying. I'll investigate it later.

deleting 200 messages now takes ~0.7 seconds which is a great improvment! (before it took ~30 seconds)

with r2674 displaying the message list is also faster... 5 seconds improvment for uncached messages, and like 10 to 15 seconds improvment for cached messages

huge thanks so far please let me know if I can test more code :)

Regards, Martin _______________________________________________ List info: http://lists.roundcube.net/dev/