OSCommerce problem in advanced_search_results.php
Posted: Thu Feb 19, 2009 4:15 am
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
Vandana
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
Vandana