Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Eliminating queries from the code


demon2lima

Recommended Posts

Can any one tell me all of the places that this query is generated from?

 

select count(*) as count from categories where parent_id =

 

I have turned off category count and removed the duplicate query from the general.php file but I still get between 10 and 30 queries like this per page load. I am running STS PLUS but it doesn't seem to make this type of request.

 

Please help!

Link to comment
Share on other sites

It could be in a number of places depending upon your code. Just search all of your files for

count(*) as count from categories where

and you should be able to find it.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

As far as I remember, this query is used in the categories infobox, to find the number of subcategories. The best is to use the cache function for this infobox.

 

- Rigadin

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...