×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Any ideas about the best data access object model?

Any ideas about the best data access object model?

Any ideas about the best data access object model?

(OP)
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

RE: Any ideas about the best data access object model?

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.

RE: Any ideas about the best data access object model?

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

RE: Any ideas about the best data access object model?

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close