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

Using Dynasets vs. Using Data Controls

Question:
In writing a VB database application, is it more effecient to open up the database once in the beginning of the program, and build queries/recordsets to access the appropriate information, rather than, setting numerous data controls on all your forms, and using them for the source of your information?

Essentially, does each data control instance relate to an additional "open" on the database?

Answer:
It depends on what database you are using. If you are using Access on a single machine, you can do either one without any major penalty. You can use a combination, since it is much easier to show a grid with data using a data control than any other way. If you are running via ODBC or through other databases, the data controls will do the same thing as creating a dynaset, since that is what the Recordset property actually is. If you are on a slow network, this can really bog things down.

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