[ic] Improve speed on retrieving data

Michelle Wilant interchange-users@interchange.redhat.com
Thu Jan 17 00:58:00 2002


Please share a sample of how you are planning to do your 'faster method' 
with an external command.  

Mike Heins wrote:

>Quoting Peter Jakl (peter@jakl.net):
>
>>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?
>>
>
>Absolutely.
>
>[tmp list_of_sku][your-command][/tmp]
>
>The above should return a space-separated or newline-separated list of SKUs.
>
>[loop list="[scratch list_of_sku]" more=1 etc=etc]
>	[loop-data ....]
>[/loop]
>