Where is the bottleneck?
Posted on 2012-08-28
Hi, I hope I can explain my issue and get some ideas:
I basically load QueryResults into a dataset and loop through those results and perform calculations on the results.
This is all happening fine when my QueryResults are, lets say > 500 records. Once the QueryResults become a set of 1500 rows, for example, my server load on the DB goes way high and the operations take a minute instead of 5 seconds or less.
Where do I need to split the operations. Is 1500 rows just too big a result to process?