Search Forum Home   DotNetNuke  CATALooK.netStore  Performance Tip...  Re: Performance Tips Please    6/23/2010 12:58:57 AM CSmith 2 posts Re: Performance Tips Please Salar, Just curious, where you using the core FriendlyURL  provider? Or perhaps a third party (Ifinity URLMaster)? I have been using Ifinity's free FriendlyURL provider and performance seems pretty good using similar hardware.  6/25/2010 12:22:28 PM feelyd 35 posts www.handyhardware.ie Re: Performance Tips Please For performance improvements on www.handyhardware.ie we modified some of the source code. The biggest issue we found and it may have been changed in later versions of catalook was the number of database calls. If you are comfortable with SQL Analyser your should run your catalook database through it to see what I mean. One routine CAT_GetSingleProducts was been called a number of times per page on www.handyhardware.ie , after adding the result of that routine to a cached object the site really took off performance wise. If you need any more information just email me.  6/25/2010 9:02:06 PM salaro 11 posts www.salaro.com Re: Performance Tips Please Firstly Thank you CS Smith After a lot of evaluation, we noticed that Good implementation of Friendly URL can indeed improve things by maximum of 50%. The issue here is much bigger. So we think we need to isolate what is causing the excessive time outs. Regards Salar  6/25/2010 9:21:32 PM salaro 11 posts www.salaro.com Re: Performance Tips Please Thank you Feelyd I would be grateful for an insight into your approach in adding the result of the routine Cat_GetSingleProducts into a cached object. I wonder if it would be possible to put it to DNNSoft to perhaps add it as an enhancement Please let me know more at >> support <(AT)> salaro . net << Regards Salar  6/30/2010 12:02:29 AM SCI-13921 5 posts Re: Performance Tips Please +1 on any code tweaks you may share with the group Feelyd ;) I still need to implement the store on my site, but when I was investigating performance issues (30k products) I found there were a lot of gains to be had in the localization stored procs of catalook. There are a lot of SQL REPLACE commands when searching and the search function builds a localized temp table for each search made. I proposed an option to the Susan to allow localized tables of product data to be built periodically or via  a trigger so the hit of localizing the data only happens occasionally, but I never heard if it was an accepted feature request. Given how often product names/descriptions are added/changed vs searched, I thought this was a reasonable idea. I also explored doing this myself using a down and dirty, non-intrusive trigger that added the data to a new table, where I could index that data using SQL indexing services - seemed to work pretty well. I still haven't gotten back to that project as the store isn't live and there are more pressing issues I need to deal with, but that's my 2 cents. TJ  Page 2 of 2 Previous12    DotNetNuke  CATALooK.netStore  Performance Tip... Flat View Tree View Oldest To Newest Newest To Oldest