General information
Title:
Select Count(*) performance
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only