[ic] sql query slower than expected
Josh Lavin
josh at myprivacy.ca
Fri Feb 16 14:05:07 EST 2007
On Feb 16, 2007, at 12:34 PM, DB wrote:
> I'm running IC 5.4.2 with mysql. My products table includes several
> brands, ands each has a unique value for the category field. One brand
> (category=BRAND_A) has many more skus that the others, nearly 250,000.
>
> I want to display the skus from BRAND_A and the following query
> does the
> job, however it is much slower than I expected and I can see the
> server's CPU load spike up while it is running.
>
> I do have the category column indexed. Can someone tell me why this is
> so slow? My server is a dual Xeon with 4GB of Ram. Is this query that
> horribly inefficient?
>
> [query
> type=list
> more=1
> ml=75
> sql=|
> SELECT sku, description, comment, category
> FROM products
> WHERE category = 'BRAND_A'
> |]
Do you have an index on your category column? Also try the arrayref
feature of the [query] tag, and return the results with Perl:
http://www.icdevgroup.org/docs/optimization/index.html
--
Josh Lavin
Kingdom Design http://www.kingdomdesign.com/
More information about the interchange-users
mailing list