haider2016

ExecuteSQL or Find?

Discussion created by haider2016 on Jul 23, 2017
Latest reply on Jul 26, 2017 by haider2016

Hello there,

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.

Kind regards

Screen Shot 2017-07-23 at 14.08.06.png

Outcomes