Hi all,
I am trying to draw data out from a database and come up with 2 ways to do it and am just wondering which way would be faster.
1, connect to the database for multiple times (5-6) and each time drawing the specific information out. and have a few separate loops.
2, is connect to the database once, grabbing all the information needed and have a few nested loops.
by the way, this might be useful too... I am using an odbc database.
Thank you.
I am trying to draw data out from a database and come up with 2 ways to do it and am just wondering which way would be faster.
1, connect to the database for multiple times (5-6) and each time drawing the specific information out. and have a few separate loops.
2, is connect to the database once, grabbing all the information needed and have a few nested loops.
by the way, this might be useful too... I am using an odbc database.
Thank you.