123 Eng

Engineering the engineers™


Latest Jobs   Forum Map

 


Home

Source Codes

Engineering Colleges

BE Students

Training  Reports (updated)

Seminar Reports (updated

Placement Papers (updated)

Forums

   Computer Science / IT

   Electronics

   Electrical

   Mechanical

   Chemical

   Civil

   CAT / MBA

   GMAT / Foreign MBA

Latest Jobs

Engineering Jobs / Technical Jobs

Management Jobs

Sitemap

About-Us

Terms of use

Displaying  Source Code(s)  
 

 
Should I use ADOVBS.inc for declaring constants?

--------------------------------------------------------------------------------



Sadly, VBScript does not understand ADO constants, such as AdLockReadOnly, the way VB does. Luckily (or
unluckily) for the developer, the immense number of constants for use with ADO is compiled in a file called
ADOVBS.inc. When starting out with database development, everyone is told to use the constant names (as opposed
to their integer counterparts), and to include ADOVBS.inc. This recommendation is given by many people, even if
you are only using 2 or 3 of the 393 constants that are listed in ADOVBS.inc.
These 393 constants result in an overall raw read size of 14,639 bytes. Never mind the amount of memory allocated
to holding all of those variables, most of which you have no intention of using. On a small, single-user app, you
won't see a difference. However, when you have 300 people on your site at once, every single user has to load that
15kb file, and every user has 393 extra page-level variables in memory... this can really add up.

--------------------------------------------------------------------------------
 

 

 

Contribute content or training reports / feedback / Comments
job placement papers
All rights reserved copyright 123ENG