DB/VB design opinion request, be quick for the points.
Posted on 2002-06-26
This isn't a "how to" question; I know how to do both ways. THis is a "which is best, and why" question:
I'm using VB client, Network based DB, max simultaneous users 20 viewing mostly different data (not transaction heavy), is it better to:
-Open a bunch of recordsets at client-startup & leave 'em open during session.
-Open & close recordsets upon request of client each time DB access is necessary (which might be once evry 30 seconds to once every 10 minutes)
I'm currently using Access, but I'm gonna migrate to SQL Server or Oracle as soon as the LAN Admin guy gets his act together. ADODB connection. Sessions might last 3 to 8 hours.
Thanks in advance for sharing your experience & knowledge.