feld on Nostr: nprofile1q…5jjde so, I was having some super weird performance issues with folders ...
nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqpm9cq65kat8aeh4jlwyxtc03ml4tz334ee4tsn7t3sk8qgraknuqp5jjde (nprofile…jjde) so, I was having some super weird performance issues with folders and it was very obvious when using something with no cache like Roundcube
so I started digging, tested against another account with a lot of mail and my giant Archive directory there was blazing fast.
So I started digging deeper and deeper and realized that somehow some of my giant mailing list archives had tons of mail that were literally out of order. If I did an aoxexport to an mbox file you can plainly see they're not sorted chronologically at all, and that's bad. I have no idea how the data ended up like this.
So I used aoxexport to dump the messages to an mbox, used a python script to write a new mbox file with all the mails sorted (and ones without having any Date headers discarded!), then re-imported the data.
That fixed the performance. Now paging through the mail folders is almost instant.
so I started digging, tested against another account with a lot of mail and my giant Archive directory there was blazing fast.
So I started digging deeper and deeper and realized that somehow some of my giant mailing list archives had tons of mail that were literally out of order. If I did an aoxexport to an mbox file you can plainly see they're not sorted chronologically at all, and that's bad. I have no idea how the data ended up like this.
So I used aoxexport to dump the messages to an mbox, used a python script to write a new mbox file with all the mails sorted (and ones without having any Date headers discarded!), then re-imported the data.
That fixed the performance. Now paging through the mail folders is almost instant.