REALLY slow search!!

[cathobby]

My search is soooo slow, most customers just give up!
Do you have any suggestions or solutions to this problem? Is there anything I can do to make the search faster???
Please help!!!

[Jamie]

Hi Cathobby,

I believe this is happening because you have a very large product database. You can increase your search speed dramatically by excluding the "Description" field on your products from the search. To do this, you will need to modify "squirrelcart/simple_search.php" file. It looks like this:

<?
if (!$in_admin_section) {
$query_table="Products";
$query_mode = "simple";
$qry_fields[] = "Name";
$qry_fields[] = "Description";
$qry_fields[] = "Keywords";
$qry_fields[] = "Category";
}
$where = record_search($query_mode,$query_table,$qry_fields ,$search_template);
?>

Remark out the "Description" field like so:

<?
if (!$in_admin_section) {
$query_table="Products";
$query_mode = "simple";
$qry_fields[] = "Name";
// $qry_fields[] = "Description";
$qry_fields[] = "Keywords";
$qry_fields[] = "Category";
}
$where = record_search($query_mode,$query_table,$qry_fields ,$search_template);
?>

You can also do this in the advanced search if you wish. That file is "squirrelcart/search_advanced.php".

Thanks,
Jamie