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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date