Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

Removing a slow Query


1 reply to this topic

#1 cau96176

  • Community Member
  • 12 posts
  • Real Name:Michael Hernon

Posted 09 September 2010, 21:43

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

#2 bonester1981

  • Community Member
  • 13 posts
  • Real Name:Thomas

Posted 06 October 2010, 18:59

look at upcoming_products.php

next time give a coding tool like pspad a try and search in your folders!