Hello.
I have a table with 200 000 records. (not much i think)
I do next SQL Select to display how many products in each group

Select group, Count(*) As _count;
FROM table;
Where table.manufactureID = manufactureID;
GROUP By group;
ORDER By group;
Into Cursor _curgroup

As result I have 420 records.. but my SQL time nearly 3 seconds.
I have index by ManufactureID and by Group for Rushmore optimization.
I have very fast computer with 1Gb RAM.

Is it normal performace? May I get performance better? Because when i navigate in form from one Manufacture to another.. I have 3 sec delay.. and it looks not good ;(

Thanks
Denis