Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] Faster search with mysql



Is there any way to get the value of "mv_sql_query" passed directory to the
SQL server? I want to be able to speed up the search against 120,000
products. I don't want to use the [query] tag on the results page since I
will lose interchanges ability to cache products and use the results paging
feature.

In all attempts, in using mv_sql_query, interchange still passes "select *
from products" and then filters the list based on the criteria itself. I can
speed up the search significantly if interchange would just send the
mv_sql_query directly. It looks as if this was the intent and could really
provide a benefit, but is not working for me.

Peter



Search for: Match: Format: Sort by: