Results 1 to 19 of 19

Thread: [RESOLVED] ADO v DAO - Why is DAO faster?

Threaded View

  1. Oct 18th, 2006, 01:43 AM #1
    lintz
    lintz is offline

    Thread Starter
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Resolved [RESOLVED] ADO v DAO - Why is DAO faster?

    I've always used ADO when using Access databases but just recently I've taken over a project where DAO has been used.

    I've extracted a module from the project to use is another project (which I started using ADO). The problem is the ADO code takes around 5 times longer than the DAO code.

    I have attached a sample project which shows how much quicker the DAO code completes compared to the ADO code. The database is a cut down version of what is used so 5 times longer can equal a long wait....

    Why would ADO be so much slower than DAO?
    Attached Files Attached Files
    Last edited by lintz; Oct 18th, 2006 at 01:46 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width