Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Removing a slow Query


Guest

Recommended Posts

Posted

Hi All!!

 

I think I'm getting the hang of this stuff.....however I was wondering if the query below can be deleted from an index.php page without an adverse effect. (I don't have expected products)

 

 [29] => select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 10

 

-----question 2......where is it being queried from? I have had a quick look at index.php, categories.php and application_top.php

 

but cannot seem to pin it down.

 

Cheers,

 

Michael

  • 4 weeks later...

Archived

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

×
×
  • Create New...