[AccessD] Memory hit

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