[Resolved] Low loading view

[Author]

Posts

[kyleH-6]

Hey guys,

I have a view on hidden link

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.

Thank you in advance,
Kyle

[Minesh]

Hello. Thank you for contacting the Toolset support.

Are you loading all 55000 results at a time? If yes, then you should add pagination:
- https://toolset.com/documentation/legacy-features/views-plugin/views-pagination/

Here is the Doc that you should try to follow that offers some tips related to cache that might help you as well:
- https://toolset.com/documentation/legacy-features/views-plugin/how-to-use-views-parametric-search-on-large-sites/