[AccessD] Memory hit

I know, and I sympathize, and I even do it myself, simply because it's so
easy to add an entire module even though I might, in this given app, require
only one or two functions in said module. I do it, too. But I'm hailing back
to my earlier days in lower-level languages and thinking that this is a
stupid approach to building an app.

I think that I want to include only the code that is actually used. In my
case, that means that I have to break a few modules into a few dozen
procs/subs; but I cannot help but think that rolling the whole WalMart
library/class lirbrary into each successive app is lousy programming.

A.


On 6/9/07, Dan Waters <dwaters at usinternet.com> wrote:
>
> Arthur,
>
> Nothing makes or breaks the case like good test data.  Please publish this
> data when you're finished!
>
> << I am not entirely sure how to check this, other than
> to write a one-proc app that does nothing more than MsgBox and then add
> several of my libraries to it, measuring the footprint before and after
> adding said libraries. >>
>
> I do use a separate Library file which is identical for all
> customers.  This
> is referenced by the Main FE file.  Not all of my customers use all the
> code
> in the Library file, but it sure is faster for me to keep common code in a
> common file!  I also do frequent updates remotely based on their requests
> or
> my improvements.
>
> Thanks!
> Dan
>
> On 6/9/07, Shamil Salakhetdinov <shamil at users.mns.ru> wrote:
> >
> > Hi Arthur,
> >
> > AFAIK MS Access loads whole modules.
> > Once loaded they stay in memory until MS Access quits.
> >
> > MS Access loads standard modules on demand - as soon as a
> > function/sub/property of a module is called this function's module is
> > loaded.
> >
> > Class modules' are loaded on class's instance creation.
> > For class modules just one copy of module's code is loaded but every
> > instance has its own in memory copy of non static module level
> > variables...
> >
> >
> > --
> > Shamil
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> > Sent: Saturday, June 09, 2007 7:21 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Memory hit
> >
> > Suppose the following scenario:
> >
> > 1. I have a huge library of code, stored as classes or just functions
> and
> > procedures.
> > 2. I drag this library into my current app.
> > 3. 70% of the code in said library is un-used in said current app.
> >
> > What is the cost in terms of physical disk size (can this be
> calculated?)
> > and in terms of RAM? If I call one function in a library that contains
> 30
> > functions, does Access load the one or all 30?
> >
> > A.
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>