[ic] Improve speed on retrieving data

Peter Jakl interchange-users@interchange.redhat.com
Fri Jan 11 15:47:01 2002


I have an important deadline and need help desperately. I apologize for
not researching this if this is simple.

I basically have the following:

[query st=db list=1 more=1 ml=20 sql='select sku from products where
...']

The select is doing a sloooow keyword search on a database with 179,000
products. I'm using mysql. I have a much faster method of generating the
list of skus, but need to run an external command.

Is there some way to run this command to generate the list of skus,
while preserving the "more" and "list" feature?

TIA!!

Peter