[ic] Improve speed on retrieving data

[interchange-users@interchange.redhat.com (Mike Heins)]

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]

-- 
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>

If you like what you're gettin', keep doin' what you're doin'. -- Hector