Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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 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 1.1.7.7C 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 ?

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

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