Using ProductCart - Increase Performance

Increase Performance

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2650
Printed Date: 27-February-2025 at 8:39am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Increase Performance

Posted By: vmarket
Subject: Increase Performance
Date 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?

Replies:

Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: vmarket
Date 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 - 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 - http://67.199.55.45/cart/pc/viewCategories.asp?idCategory=101

Posted By: RUOnTheNet
Date 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

Posted By: vmarket
Date 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, ( http://www.crystaltech.com - 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?