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?
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.
Source, Tips, Tricks, Components
"Andrea" <email@example.com> wrote in message
> 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
> have any suggestions?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL