Speed issues connecting to a database.

[Andrea]

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?

[Robert Gelb]

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?