Speed Issue

I uploaded my products (over 62,000) and find accessing a specific product to be unbearable slow. Is this too much for LiteCart's capability, or is there something I can do to speed it up?

I am evaluating LiteCart as a replacement for osCommerce, which I have been using since 2007.

The (incomplete) test site is at http://cheyn.us/litecart.

Holy moly! A browsable catalog with 62,000 products. Looking at your site it takes 2,5 s to load the page and just about the same amount of time to render the page. You can use Chrome to debug this by turning on the developer tools and see the network timeline.

There are a few things we could try here.

1. Install a satellite from webhosting-performance.com and see what your machine's MySQL performance is.

2. Add more keys for table indexing in case the current ones are not enough.

3. Turn off heavy elements like the DHTML site menu of categories.

4. Do some experimenting on the query in functions/catalog.inc.php and see if there is any optimization that can be done there.

How are your web skills? I assume they are in great shape since you managed to insert 62,000 products.

One of the advantages/disadvantages with osCommerce is how it outputs HTML contiounsly. That has a great effect on performance but a lot of technical possibilities goes to waste. Like how LiteCart makes use of template snippets etc.

62,000 products is nothing; I have one affiliate site with 200,000 products!

Thanks for the feedback and thoughts. Don't know what I'm going to do yet. I might have to stick with osCommerce for the speed and sacrifice the other features for now.

If you want you can send us a database dump of your mysql database to support (a) litecart.net. We would then install that on a machine here and do some heavy testing. Great performance is in our interest. So far it has been a loss of functionality in every aspect of reconstruction for performance gain.

--

Edit 1 dec:

I did find code that I could optimize but the bigger issue is your 1,000+ categories. When editing a product it's a 12,000 rows HTML page being loaded just to provide the box to select categories. :(

It's not a problem loading 1,000 categories if they were not multidimensional. MySQL only returns a flat result. I'm thinking of a solution for this.