Most likely it's your database causing slow issues from what you've described. Try throwing more hardware at your MSSQL server or use this:
http://msdn.microsoft.com/en-us/library/ms187929.aspx
Get a profile on your most expensive queries and see if you can do some optimization like doing some indexing to try and get a decent speed increase.
ASP POOL RECYCLING PROBLEM. PAINFUL & SLOW LOADINGS.
- 45
- 309
- 8/13/2010
- United Kingdom
UbikoDesigns wrote:
I had to laugh at the dude who thinks 20seconds for one page is fine.
Do you have lots of products? I found nop commerce fine for small sites but more than a few thousand items and it ground to a halt (I ended up using a paid solution that ran like a rocket)
Sorry for the late reply, yes i tried with and without debug mode. It's still doing the same thing.
20sec loading pages is definately NOT acceptable... =/
20sec loading pages is definately NOT acceptable... =/
I had to laugh at the dude who thinks 20seconds for one page is fine.
Do you have lots of products? I found nop commerce fine for small sites but more than a few thousand items and it ground to a halt (I ended up using a paid solution that ran like a rocket)
- 15
- 95
- 5/11/2011
- United States
windupstudios wrote:
That could be it! I believe the original pictures i uploaded were MASSIVE like 1-3megabytes! Are they directly stored in the SQL server? I saw that the pictures were stored on the web server with the NopCommerce install, so i replaced those thinking thats where they were stored but if they actually are in the SQL server that would explain it.... if so..how do I replace them with lower size/quality pictures?
Sandman wrote:
I don't have a lot of products, about 40...
Thanks for any assistance you guys! It is greatly appreciated!
Most likely it's your database causing slow issues from what you've described. Try throwing more hardware at your MSSQL server or use this:
http://msdn.microsoft.com/en-us/library/ms187929.aspx
Get a profile on your most expensive queries and see if you can do some optimization like doing some indexing to try and get a decent speed increase.
http://msdn.microsoft.com/en-us/library/ms187929.aspx
Get a profile on your most expensive queries and see if you can do some optimization like doing some indexing to try and get a decent speed increase.
That could be it! I believe the original pictures i uploaded were MASSIVE like 1-3megabytes! Are they directly stored in the SQL server? I saw that the pictures were stored on the web server with the NopCommerce install, so i replaced those thinking thats where they were stored but if they actually are in the SQL server that would explain it.... if so..how do I replace them with lower size/quality pictures?
Sandman wrote:
Sorry for the late reply, yes i tried with and without debug mode. It's still doing the same thing.
20sec loading pages is definately NOT acceptable... =/
I had to laugh at the dude who thinks 20seconds for one page is fine.
Do you have lots of products? I found nop commerce fine for small sites but more than a few thousand items and it ground to a halt (I ended up using a paid solution that ran like a rocket)
20sec loading pages is definately NOT acceptable... =/
I had to laugh at the dude who thinks 20seconds for one page is fine.
Do you have lots of products? I found nop commerce fine for small sites but more than a few thousand items and it ground to a halt (I ended up using a paid solution that ran like a rocket)
I don't have a lot of products, about 40...
Thanks for any assistance you guys! It is greatly appreciated!
- 481
- 2782
- 7/24/2010
- India
I am also on Arvixe www.lanoscomputers.com facing same issue, and every the Arvixe support team restart the SQL server issue resolves for me, I am behind them to fix this issue once for all, but they are adament in saying its something wrong with the code and their system are all set and running fine, day before my site went down 4 times and SQL server restart fix the issue, I guess Arivxe surely has some issues with thier server or does Nop? I am confused at the moment, they are suggesting me to go for business class package which is about $40 a month, thinking what to do..