TotalChoice Hosting Family Forums: Optimizing Oscommerce - TotalChoice Hosting Family Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Optimizing Oscommerce Database Queries

#1 User is offline   SkydiveUK24 

  • New To The Neighborhood
  • Pip
  • Group: Members
  • Posts: 18
  • Joined: 18-August 05

Posted 20 August 2005 - 08:06 PM

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?

#2 User is offline   TCH-Don 

  • Volunteer Moderator
  • PipPipPipPip
  • Group: Moderators
  • Posts: 11,679
  • Joined: 30-November 02

Posted 21 August 2005 - 06:44 AM

hang in there, I am sure a family member that uses Oscommerce
will be along soon.
Don Rosenquist
Forum Moderator
TotalChoice Hosting, L.L.C.
Web Hosting by Total Choice Web Hosting - For Your Family - Web Hosting Family!

Any links or suggestions for third party software/sites should be used at your own risk.
My opinions and recommendations are not necessarily those of TCH and TCH is not responsible.

I am a Forum Moderator and a volunteer. While I can assist in answering most of your hosting related questions, I am unable to answer questions about specifics relating to your account such as billing and server related questions. Should you need assistance in these areas, please contact our Help Desk.

treasure your pets

The Turtle says "A little knowledge is a dangerous thing,
so keep learning!"

#3 User is offline   SkydiveUK24 

  • New To The Neighborhood
  • Pip
  • Group: Members
  • Posts: 18
  • Joined: 18-August 05

Posted 22 August 2005 - 11:01 AM

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.

#4 User is offline   TCH-Rob 

  • Help Desk Manager
  • PipPipPipPip
  • Group: Members
  • Posts: 7,818
  • Joined: 11-March 03

Posted 22 August 2005 - 03:42 PM

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.

#5 User is offline   SkydiveUK24 

  • New To The Neighborhood
  • Pip
  • Group: Members
  • Posts: 18
  • Joined: 18-August 05

Posted 22 August 2005 - 09:19 PM

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 :(

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users