Any ideas about the best data access object model?

calahans · Sep 9, 1999

I was wondering if people had any ideas in regard to the best object model to access a database. Obviously ADO is being put forward by microsoft, I've heard off other developers that RDO is better for the moment and that ADO is a release or two away from being the choice. I've used both and prefer ADO, but I'm wondering what others think. 
 
I'm currently developing an application which will sustain alot of user activity to a certain few tables. We're thinking about using ADo and dislocated recordsets - has anybody experience of using these are they messy? What is the performance like? 
 
Thanks

johnk · Sep 9, 1999

Our small app development firm has been using VB6 and ADO quite successfully for several months. In fact we now use nothing else. 
 
Performance for us is outstanding. However, a number of factors are involved. Our apps serve maybe 10 users concurrently so we don't use MTS for pooling connections. Rather we create 2 connections for each user at sign on, and use them for all data access for that user as long as he stays signed on. 
 
Disconnected recordsets are also a big success for us. We use them exclusively for everything but updates. For updates we reread as necessary to update. Of course we must guard against a record changing in the meantime, but we have worked out a practical way to deal with that. The end result is that any unwanted record locking is a thing of the past for us. 
 
This has resulted in more code being required than with other techniques. Much of it is in our data access module which is shared by all. The rest is supplied by our homemade code generator.

trebort · Sep 10, 1999

Thanks John, 
 
that helps a great deal. I was thinking of using disconnected recordsets but no one I knew had used them in any great amount. The last thing I wanted was to start into development down the wrong path. 
 
One other question: 
 
Do you ever write static data recordsets to the local hard disk, or is this over the top? 
 
Thanks, 
 
C

johnk · Sep 10, 1999

C, Be warned that I'm a manager and no longer up on many details. I'll try to get my staff to correct any misinformation I may inadvertantly pass out. 
 
While we haven't put database tables on local disk for performance, we make a lot of use of loading reference tables into local ram during form load. We were forced into this in order to provide what Microsoft calls Intellisense, we call it Autofill. That's where the user may key into a text box and the system fills out matching entries with each keystroke. 
 
I'm interested in your ideas & would like to stay in touch. 
 
John

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Any ideas about the best data access object model?

calahans

Programmer

johnk

MIS

trebort

MIS

johnk

MIS

Similar threads

Part and Inventory Search

Sponsor