Database Access
-
We are developing an application that connects to a database. Can anybody tell me which is better on database access? First, One time access to the database(loads all database contents to a to a vector or recordset) then update the changes to the database whenever necessary. This is usually done on the application start-up.Second option is to load database contents(data which is only needed for a particular dialog) then update database when there are changes. For me the second option is better because it does not consume much memory resources and only the needed data are accessed whenever needed. What do you think guys?
-
We are developing an application that connects to a database. Can anybody tell me which is better on database access? First, One time access to the database(loads all database contents to a to a vector or recordset) then update the changes to the database whenever necessary. This is usually done on the application start-up.Second option is to load database contents(data which is only needed for a particular dialog) then update database when there are changes. For me the second option is better because it does not consume much memory resources and only the needed data are accessed whenever needed. What do you think guys?