It queries 55,000 results, which makes the page load incredibly slow. We're using the number of views, stored as a custom field, to sort the list by popularity. But this calculation seems to happen every time the page is loaded, which cancels the cache and makes the whole experience incredibly slow.
Do you have any ideas/experience of how I can cache the results of the filters for say a week? Irrespective of if the data about the views changes. Or experience in handling such huge amounts of data.
