Advanced Search and Advanced Search Results

[Guest]

I am using OSC and have 12700 products in my dB. I have modified the advanced_search_results.phpand advanced_search.php files to allow for independent searching of the products descriptions, product name, manufacturers name, date ranges, and a new field that I added to the dB and search pages that searches a field of related terms for any specific record in the dB.

 

I noticed that the search is slow, extremely slow, taking as long as 10-15 minutes. Does anyone think that the joins in the SQL statements are the problem, would subqueries work better? Also, what is the purpose of the:

 

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, .....

 

code in the advanced_search_results.php file. :(