On 2025-04-30 02:51, Arnt Gulbrandsen wrote:
Mark Felder writes:
Suggested indexes I manually added:
I'm very puzzled by these. Do you have any insight into what queries
benefited?
Not specifically. I understand the reasoning was due to the number of
full table scans that were occurring as that was indicated in its
output.
I can guess what Roundcube does.
There's an IMAP extension called SORT, which I really dislike. Abhijit
or I tried to implement it, there was some bug, and I think I
eventually removed it from the list of capabilities. I'm sure it's
fixable.
Roundcube probably doesn't use it in this case. The best way forward is
to fix sort well enough for Roundcube.
I just tested Rainloop as an alternative webmail interface and it
doesn't permit me to do any sorting of the mail folders at all because
it detects the IMAP server doesn't have any SORT capability.
You want the messages sorted by the value of the Date field, right?
Persistently?
Yes, because without a client that can download the whole mail folder or
at least the headers and do local sorting it seems very common for the
mails to be randomly sorted when listing the mail folder contents. I am
guessing it's just returning exactly the order that's in the table? If
you delete a bunch of mail then new mail starts filling in those holes
in the existing table and it gets progressively worse...
