in reply to How to increase the efficiency of the code wen working with DB?
Is there a way that you can let the database handle the loops? Perhaps rewriting two or three of your queries as joined queries, and returning the data all at once would allow the DBMS to optimize the query a bit.
--MidLifeXis
|
|---|