Increase Performance

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

   Hello.  

I am developing a rather large ecommerce application using PC.  The site sells screws and fasteners, and the store has approx 2000 categories/subcategories and just over 40,000 products.  Some categories contain several hundred products, (displayed 25 per page in list format), and it seems that any category with more than 2 pages worth of results takes a long time to load - up to 15 seconds or more.

Anyone have any suggestions as to how I can increase the performance speed of the cart?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
vmarket Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-April-2009 Status: Offline Points: 0	Post Options Post Reply Quote vmarket Report Post Thanks(0) Quote Reply Topic: Increase Performance Posted: 15-April-2009 at 1:51pm
	Hello. I am developing a rather large ecommerce application using PC. The site sells screws and fasteners, and the store has approx 2000 categories/subcategories and just over 40,000 products. Some categories contain several hundred products, (displayed 25 per page in list format), and it seems that any category with more than 2 pages worth of results takes a long time to load - up to 15 seconds or more. Anyone have any suggestions as to how I can increase the performance speed of the cart?

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 15-April-2009 at 3:03pm
	Hi, One scenario I've seen which impacts a store such as yours is where the navigation menu contains all the categories/subcategories. This results in the navigation part of the page code being far and away the largest part of the page and can hammer performance. Limiting the menu to top level categories helps in such circumstances. Having hundreds of categories at the top level, or within another category. can make it difficult to navigate and slow to load. Do you have a URL you can post?
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

vmarket Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-April-2009 Status: Offline Points: 0	Post Options Post Reply Quote vmarket Report Post Thanks(0) Quote Reply Posted: 15-April-2009 at 4:42pm
	We are using a static navigation (part of the template), not the dynamic nav that PC generates. Here is the URL to our proof site: http://67.199.55.45/cart/pc/home.asp Here is an example of one of the pages that experiences long load times, (it seems to happen on Subcategory pages that load more than 2pgs of products) http://67.199.55.45/cart/pc/viewCategories.asp?idCategory=101

RUOnTheNet Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 06-November-2008 Location: Vancouver Status: Offline Points: 0	Post Options Post Reply Quote RUOnTheNet Report Post Thanks(0) Quote Reply Posted: 16-April-2009 at 12:23am
	First, you have a nice clean site. Kudos. Your site is alppearing to load slowly here, but I think it is a dbase connectivity issue. If you are using access (which we use for one client) you might consider moving to MSSQL as it will make a huge difference in load time with your product lists/item numbers. And you should talk to your ISP, (they are actually a reseller of a larger hosting company I think) and ask them to tweak your box so you get a better connection. I think they can do this my modifying the simultaenous threads. Which brings up another question to ask - and for you to try. Organize a group attack on your own store front to make sure your site isn't reallly slow when more than 5 people are quering the site/dbase. Alan
	Alan, www.AreYouOnTheNet.com Internet Sales, Marketing & Affiliate Program Management

vmarket Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-April-2009 Status: Offline Points: 0	Post Options Post Reply Quote vmarket Report Post Thanks(0) Quote Reply Posted: 20-April-2009 at 11:49am
	Hello Alan. Thank you for the response. We are running a SQL2005 server for this site. The hosting company we are using for this account is CrystalTech, (www.crystaltech.com). I have submitted a support ticket to see if there is anything they can do regarding the connection. A 'group attack' is something I havn't thought to try. Is there an automated method you can suggest for doing so, or is it just matter of having 5 or 10 people in the office start jumping around the site to see how it does?