Slow message search
evolution-3.34.4-1.fc31.x86_64 evolution-data-server-3.34.4-1.fc31.x86_64 sqlite-3.30.0-1.fc31.x86_64
Steps to reproduce
- I have a folder (IMAP but fully locally cached) with >700000 messages.
** In this folder, ~32000 messages were received within the last 28 days
** In this folder, 18800 messages (received at any time) have the string
[Edited]in their subject line ** In this folder, 787 messages have the string
[Edited]in their subject line AND were received within the last 28 days
- I set up a Saved Search with the following values:
- I run this search
Evolution runs for more than an hour, according to
top takes 80% of my memory and CPU, and still does not display the search results.
The search plan is intelligent enough to first run a query on date; second run a query on the subject line; and only third executes the rest of the search conditions on this small remaining subset, and all that takes a reasonable time until displaying results which is less than an hour given the numbers above.