Site is very slow

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I have a site that is supposed to go live this week. I keep timing out when accessing the database to find a product and other database calls.

I contacted the hosting company who said that this is not their issue, as the server that it is on, is nearly empty and aside from my site, the performance is much quicker on other sites calling the database.

They suggest that this is a software coding issue. Can someone please let me know what I can do to improve the speed.

Site is www.kennethreeve.com/store/pc.

Thanks.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
dccreatives Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 13-November-2008 Status: Offline Points: 20	Post Options Post Reply Quote dccreatives Report Post Thanks(0) Quote Reply Topic: Site is very slow Posted: 29-November-2010 at 12:34pm
	I have a site that is supposed to go live this week. I keep timing out when accessing the database to find a product and other database calls. I contacted the hosting company who said that this is not their issue, as the server that it is on, is nearly empty and aside from my site, the performance is much quicker on other sites calling the database. They suggest that this is a software coding issue. Can someone please let me know what I can do to improve the speed. Site is www.kennethreeve.com/store/pc. Thanks.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 12:41pm
	It definitely seems slow. A page like the following one should be loading extremely fast: http://www.kennethreeve.com/store/pc/Sizing-Tips-d5.htm You might want to open a support ticket so that we can take a quick look at your header.asp/footer.asp code and see if we can spot any red flags. From a first look, though, this does seem an issue that is probably hosting-related. For example, it could be a particularly slow shared MS SQL server. We see this happen all the time. Who is the hosting provider? Have you hosted other stores in the same hosting environment? If so, can you check the database connection string to see if the other stores are connecting to the same SQL server or not?
	The ProductCart Team Home of ProductCart shopping cart software

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 12:42pm
	I'm not a pro, but had similar problem with a past provider. I finally had it with them after they screwed up my database. BTW that was webhost4life.com. I've contacted www.joltdigital.com after getting the runaround routine, while my store had been down for 2 days. Best call ever. They transfered the entire site, set up the sever and database connection for me free of charge! They are very familiar with PC and don't give you the run around. I'm sure there are some other good hosts out there that specialize on PC.
	Katharina ***************** www.GermanPlaza.com *****************

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 12:45pm
	I agree that it appears to be very slow. Which host is this? It's running MSSQL, correct? I wonder if they can push the databse over to another SQL server just to eliminate that as a possiblity?

dccreatives Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 13-November-2008 Status: Offline Points: 20	Post Options Post Reply Quote dccreatives Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 12:53pm
	The hosting provider is Crystal Tech - and early impact recommended them. We tried moving to a new database server and the tech guy said it was a new and nearly empty server. He claims that other sites running on that server are very fast. It's running MSSQL 2008. Is there any way to determine if it's definitely a hosting issue? They claim that it is the way the code is written that's causing issues. Obviously that's incorrect because many other PC sites are running smoothly out there...

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 1:01pm
	Might be worth copying the site to another host and see if it runs better there. Obviously you can't launch in this form - were I the client I certainly would be unhappy. Jolt may be willing to pull a copy over to their server, and I certailnly would be willing to assist you in that regard and put a copy on my server for testing. If you wish to consider this, give me a call.

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 1:08pm
	I'm running one SQL2008 and have no issues. No change in the code either. You only have to be careful when you upgrade to never versions of PC that add to the database table. Nothing major at all.
	Katharina ***************** www.GermanPlaza.com *****************

Brett Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 22-April-2008 Location: Phoenix, AZ Status: Offline Points: 89	Post Options Post Reply Quote Brett Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 3:01pm
	If you're worried that some custom code on your files is making the site go slow, you could set up a cloned folder with the default site files. http://wiki.earlyimpact.com/how_to/create_default_store?s[]=default&s[]=files This should show you how fast the default installation runs on your web server. If it's still slow then you could probably rule your files out as a problem.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 3:38pm
	We are working with dccreatives on this via our support ticket system, but wanted to update this thread with some information that might be interesting for other users: Here is category page, completely static: we saved the HTML code from the browser and FTP'd the file to the "pc" directory. In other words, ProductCart has absolutely nothing to do with this page. In our tests, it took over 10 seconds to load: http://www.kennethreeve.com/store/pc/Boyshort-c49-static.htm We started looking for potential causes for this really long loading time, and found that the loading of the Google Translate API played a big role. Here is the same exact page (again, this is not a re-written URL, this is a completely static file), without the JavaScript for the Google Translate API: http://www.kennethreeve.com/store/pc/Boyshort-c49-static-b.htm We are still researching the matter and are not sure yet as to all of the causes of slow performance for this particular Web site, but the difference in page-loading time when removing the Google Translate API was pretty staggering (make sure that you are using a completely new browser session when testing the above-mentioned URLs). Edited by earlyimp - 29-November-2010 at 3:42pm
	The ProductCart Team Home of ProductCart shopping cart software

Brett Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 22-April-2008 Location: Phoenix, AZ Status: Offline Points: 89	Post Options Post Reply Quote Brett Report Post Thanks(0) Quote Reply Posted: 29-November-2010 at 3:48pm
	If even static pages are loading slow, then it sounds like it's not an issue with the database at all, but perhaps an issue with the http server. Hopefully it's just the Google Translate API like you said.