-
I have several databases (the number of them depends on the user). Obviously I need to access them in my program (searching, adding and removing stuff). What would be faster to do:
[list=1][*]Load each item from each database to an array and then access it in my program without really opening database[*]Open and Close database everytime user wants to find, add or remove something[/list=1]
I don't use any data control ocx's (it plain code-like database creation). Also the databases will be quite big (I will have about 150 people use it, add stuff, trying to search something etc, etc.)
So what do you think? 1 or 2? ANY help would be gratefully appreciated.
P.S. I'll need to repopulate some controls (textbox, combo etc.) with the database data very often
[Edited by VBSpike on 08-03-2000 at 12:26 PM]
-
Use opt 2 if the data is going to change frequently. If it doesn't change much, you might get away with it. I would personally stay with opt 2.
