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

[ic] Improve speed on retrieving data



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




Search for: Sort by: