Optimizing Oscommerce

[SkydiveUK24]

I am having a go with oscommerce and have just installed a template, it's using STS. It had 377 queries to load the index page! So I ran some optimization contributions and got it down to Parse Time: 0.115s with 43 queries

 

However when I click on a category (this is without any products in) Parse Time is 0.161s with 179 queries. Still seems high to me, but then again I dont know that much about oscommerce - what do you guys think?

[TCH-Don]

hang in there, I am sure a family member that uses Oscommerce

will be along soon.

[SkydiveUK24]

Or not Don.. lol

 

Extra Info:

 

I have all of these enabled and working:

 

Category counts off

Added Indexes

Turned on cache in oscommerce admin

Added Config cache

Added new get_tax_rate

 

The live support chat here told me that there is no limit on number of queries per hour like some hosts, so perhaps this is not so much of a problem?

 

Site seems fast enough, I just thought lots of queries put a strain on the server with shared hosting?

 

Any info would be appreciated.

[TCH-Rob]

I ran osCommerce for a while with a few thousand items and never had a problem with server loads. It was heavile modified, running many contributions. While I do not know what is optimal, I can say that we have many members that are running it and have no issues.

[SkydiveUK24]

Thanks for the reply.

 

I wasn't happy with the database queries, so I uninstalled the STS and found a template that doesn't use it. Looking much better now:

 

Parse Time: 0.082s with 33 queries. Original osCommerce demo products and categories.

 

Now all I have to do is find a way of converting my CubeCart database to osCommerce, which I think is impossible