Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996



Building the Right Environment to Support AI, Machine Learning and Deep Learning

ODBC Slowdown

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 an ORACLE 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 on my PC, and the Oracle 7 ODBC driver. I have configured the ODBC link to my ORACLE database and can successfully connect. I have never attempted to access data via an ODBC link before...Is is always SLOW ?

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date