We are using EpiServer CMS R2, We are facing performance issue with Episerver.
We have identify that the SP name "netPropertySearchString" is highly utilize and consume lots of resources on Database server.
Our Live sites are become very slow.
Can you please suggest some points to improve site performance.
The one possible option that we are thinging is to enable EpiServer caching by putting following code in web.config file
<location path="Global"> <staticFile expirationTime="1.0:0:0" cacheControl="auto" />
Please suggest any other approach to improve site performance.
The SP "netPropertySearchString" is used when you do a property search, for instance through FindPagesWithCriteria. Since that seems to be what is slowing your site down I'd suggest that you try to identify where this search is coming from. Once you find that look into the possibility of replacing the search with something else, or caching the result.
There are not really any general approaches to improving performance. Rather, as you did, try do identify what is taking up resources and optimize that particular issue.
As for adding caching to the file paths that's probably a good thing. However, it won't affect the problem you are having with "netPropertySearchString".
Per GunsarfsEPiServer CMS development team
"netPropertySearchString" is used by FindPagesWithCriteria when searching String or Long/XHTMLString values; And FindPagesWithCriteria can be a performance killer when used improperly.
I was digging around in our Support inbox and noticed people having problem after upgrading to EPiServer CMS R2 due to bug "#25759: EPiServer.UI.Edit.XFormSelect.LoadForms calls GetxFormUsedonPages twice per xform on each request."
So are you using too many FindpagesWithCriteria?Or are you using alot of XForms?
These links might help you sort out the problem,
// Steve talks about Performance and FindPagesWithCriteriahttp://world.episerver.com//en/Video/DevSummit/Performance-Troubleshooting-EPiServer-CMS-Web-Sites-/
// Blog post about the XForm bug:http://world.episerver.com/Blogs/Daniel-Ovaska/Dates/2009/8/Xforms-performance/
//An unsupported but usefull cache project:http://labs.episerver.com/en/Blogs/Steve-Celius/Dates/112266/6/The-EPiCode-Cache-Framework/
Hope this helpsPer
Yes, we are using "FindPagesWithCriteria" method on each request of the page.
We have following senario :
We have one master site (i.e. control to all sites that we have) under that we have promo library.We are creating promos with link to one page in master site.
Then we have many child site (i.e actaul end user sites) there we are calling that promo using "page" property and on page rendering time we are replacing promo link to the child site page URL.
We are using "FindPagesWithCriteria" method to find page in related child site based on master site page, we are using one hidden textbox property for this master and child site mapping.
As we don't find any other way to do this task.
Can you please suggest how to optimize "netPropertySearchString" SP or any other way that we can achieve the same.
I'm not 100% sure on what you are trying to accomplish. What is a promo library and could you clearify what you are trying to achieve?Do you have an Enterprise site solution, how and how many sites. etc?