Speed issues connecting to a database.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Speed issues connecting to a database.

  1. #1
    Andrea Guest

    Speed issues connecting to a database.


    I am using VB6, ADO, ODBC and Access 2000. The databases are stored on a
    server. I am having some speed issues with the larger tables. Does anyone
    have any suggestions?

  2. #2
    Robert Gelb Guest

    Re: Speed issues connecting to a database.

    Your first problem is that Access 2000 is NOT an RDBMS. That means when you
    do "Select * from SomeTable where ID=1", the ENTIRE table comes across the
    wire, ADO does the comparison to locate the row with ID=1 and then hands you
    that row. Basically, you are bringing the entire table to the client - that
    is the problem.

    Second problem is that you are using ADO/ODBC/Jet to get to the data.
    That's 2 more layers than you need. So either use DAO to get to it, or at
    least use the ADO/OLEDB provider for Jet.

    My solution would be as follows - fix your data access methodology, then
    create an ActiveX EXE on the server that processes your queries and only
    hands you the necessary rows.

    --
    Robert Gelb
    www.vbRad.com
    Source, Tips, Tricks, Components

    "Andrea" <andrea@edp.unb.ca> wrote in message
    news:3a80248e$1@news.devx.com...
    >
    > I am using VB6, ADO, ODBC and Access 2000. The databases are stored on a
    > server. I am having some speed issues with the larger tables. Does

    anyone
    > have any suggestions?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center