mattbrown
Sep 25th, 1999, 06:03 PM
I am designing an application that uses DAO objects in code to reference a database.
This application will be running all day ie. 8am - 5pm, but may only be used for maybe 20 mins every couple of hours or so.
My question is, is it more resource friendly to initilise 1 global recordset object at the start and leave it open all day, whether it is needed or not, Or
to keep opening and closing recordsets when they are needed.
I would be happy to give you more information on the specifics of my application if you feel it is relevant
This application will be running all day ie. 8am - 5pm, but may only be used for maybe 20 mins every couple of hours or so.
My question is, is it more resource friendly to initilise 1 global recordset object at the start and leave it open all day, whether it is needed or not, Or
to keep opening and closing recordsets when they are needed.
I would be happy to give you more information on the specifics of my application if you feel it is relevant