The following screen shot shows a table contains almost 19 thousand records, I am trying to find how many students passed in each subject. Each subject has its own number (SubNum). I have written a script and used Find inside specifying each subject then I took the result of get(found count) , it looked nearly to 30 seconds for each subject and about 2 hours for all 290 subjects. Later I tried to use ExecuteSQL function instead of Find , unfortunately it took almost same time.
Is this normal , or it can be faster !
Any help would be very appreciated.