Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Unanswered: Data Retrival Speed

    Hi friends,
    I m using vb6 and access 2000 for my app.
    my database table has around 90,000 reocords with size of 114MB FILE size.
    Which database connection should i used for getting result using like operator. Should i used ado , rdo or dao ?
    I also want to enforce database security for my file.

  2. #2
    Join Date
    Mar 2004
    You can get the results with all three, however if you are connecting to an Access Database (i.e. JET Engine) your fastest connection will be by using DAO.

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Apr 2004


    Are you preparing your tables before openning them? You may want to try to set the prepare to true before openning. Remember you will need to update your statistics unless your database system does it automatically. The other things you can do is avoid using * in your select. Specifiy the fields you want to use. One last thing is how is your Connection doing its reads. You may want to set it to Dirty Read. I hope this helps.

Posting Permissions

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