[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Improve speed on retrieving data
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]
>