skorpionkz
Well-known Member
- Joined
- Oct 1, 2013
- Messages
- 1,171
- Office Version
- 2016
Hi guys,
I have code to read data from about 50 data tables.
Code opens connection, creates recordset and then pass it to the array. Next it close connection and then loop through the array.
I am wandering now is this would be actually better/faster to loop through the Recordset itself?
Or this would not be a good idea, as connection is remaining opened for entire loop?
Thank you,
Andrew
I have code to read data from about 50 data tables.
Code opens connection, creates recordset and then pass it to the array. Next it close connection and then loop through the array.
I am wandering now is this would be actually better/faster to loop through the Recordset itself?
Or this would not be a good idea, as connection is remaining opened for entire loop?
Thank you,
Andrew
Last edited:
