[ic] Improve speed on retrieving data

[Dan Browning]

> 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

You can run external commands with a global usertag.  See archives for
[encrypt] as an example.

However, if you are saying that the query is slow in IC but fast when
executed directly in mysql, maybe you should try today's CVS as it
removes the need for specifying rf="" so that IC doesn't have to do a
select * (which may be what is happening to cause the slowdown in your
query).  

Just ideas.  HTH,

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Dan Browning, Sr. Tech Consultant
| Kavod Technologies, 1498 SE Tech Center Pl Ste 170
| Vancouver, WA 98683  <dan.browning@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Don't say yes until I finish talking."
		-- Darryl F. Zanuck