Re: Speed problem on large tables

[Dan Holdway]

Hi Mike,

I'm running version 12.22 Distrib 4.0.20a.

If I just execute;

Select left(amazon_items.Product_Description, 1) As IndexLetter, Count(amazon_items.Amazon_Product_ID) As NumProducts
From amazon_items
Group By left(amazon_items.Product_Description, 1)

It comes back a bit quicker (8.59 sec), but still nothing like the sub-second performance I was getting with MS SQL.

Ta,

Dan