devxlogo

ODBC Slowdown

ODBC Slowdown

Question:
I am trying to create a “proof of concept” Visual Basic Project.In it, I am using a VB front end to access and maintain data in anORACLE 7 database running on a Unix server.I am running VB on a 486/66 platform under WinNT 3.51.I have loaded SQL*Net 1.1.7.7C on my PC, and the Oracle 7 ODBCdriver. I have configured the ODBC link to my ORACLE databaseand can successfully connect.I have never attempted to access data via an ODBC link before…Isis always SLOW ?

Answer:
Data controls via ODBC are going to be painfully slow, as will be dynasets. I’d advise you stick to Snapshots where you can. Unfortunately, this increases the amount of code you have to do to substitute for bound controls. I’m doing a project with exactly the same setup that you have.

See also  How HealthStream Learning Center Supports Healthcare Education and Compliance
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist