Page 1 of 1

OSCommerce problem in advanced_search_results.php

Posted: Thu Feb 19, 2009 4:15 am
by vs_indr
Hi,
I am a novice developer in osc ,I even tried to get help in oscommerceforum but found difficulty in getting help because of limited access.

I am maintaining an oscommerce store http://www.prescriptiongiant.com with aprox 12000 products .Among which 4500 products are having 4-5 options,option_values assocaited with them.

The advanced_search_results.php is taking terribly very long time to search any products (aprox 20 sec - 54 seconds!!). I have also removed the search in description criteria from advanced_Search_results.php .
Also optimized the databse ;still it didn't help. :(

Try this http://www.prescriptiongiant.com/advanc ... &x=34&y=19
Can anybody help in this !

Thanks in advance :D
Vandana