Try our conversational search powered by Generative AI!
AI OnAI Off
performance with PagedataCollection, SearchDataSource and Pagelist
Property criterias are evaluated at a database level - where as filters are applied on the in-memory data, so for large datasets its always better to filter at the database level rather than in your code.
Its tough to comment on your exact situation, not knowing exactly what you want to achieve, why not set up some simple tests if you need a definitive answer.
There are some good blog posts about this topic....
FindPagesWithCriteria and Performance (by Steve Celius) and for some metrics see Henrik Nyström's post
Mar 24, 2010 16:10
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
Hi guys
The scenario is to do a seach/filter among 1000 pages(could be more), it can be done via EpiServer SearchDataSource with Criterias or using PagedataCollection with a filter. Considering the performance, which one is faster? In my case I need to search/filter only by one or two property value then sort and present them(with a title, image and short intro).
Then there is pagelist as well, it might not be used in this case but other similar cases(pagelist + a filter to present list of pages), so how's the performace of pagelist ?
Thx guys