2.65 Slow category pages? SOLVED

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
11 лет назад
Using v2.65

I was having some performance issue relating to slow loading category pages, these pages were taking approx 6-9secs to load, which was way too long.

Fixing this problem?

I managed to move my database from SQL Compact to SQL Server 2008, doing this allowed me to use the stored procedure (that comes with the nop installation) to run the Product Search, this has greatly improved load times, which are now around 3-5 secs, much better.
11 лет назад
This tool helped analyse my page load issues too, highly recommended

http://tools.pingdom.com
11 лет назад
Hi
Thanks for the information

Kind regards
Peter
11 лет назад
Hi
Thanks for the information

Kind regards
Peter
10 лет назад
Can you please expand on how you used the stored procedure provided with nopcommerce for this?  Does this require a code change or is the a config change?

Thanks!
10 лет назад
If you use regular SQL Server rather than Compact, the stored procedure is used automatically. (No manual config is needed)
10 лет назад
Oh, I'm already using regular SQL server and am seeing a several second delay when clicking a category link.  Any other suggestions?

Brent
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.