[AccessD] Find First in an Array?

Drew Wutka DWUTKA at Marlow.com
Fri Feb 20 15:50:03 CST 2009


And this is where Global Classes come into play.

In the case of your multi-lingual app, your data may not change very
often, but it has the potential to change.  That being the case, by
putting the data in the BE, you don't have to update the FE for a simple
data change.  However, instead of constantly pulling the data across
from the BE, you load the class when your app starts up, and the data is
simply kept in memory.

Pulling a few thousand records really isn't a big deal, as long as they
aren't memo fields with megs of information.  2.5k records, with even 1k
cay of information is only going to use 2.5 megs of RAM (roughly)  In
the case where you are storing a few bytes of info, it's negligent,
especially on machines where 1 to 2 gig is standard RAM.

Even in situations like a State table (TX, AL, FL, etc.).  Sure, there
are 50 states now, but putting lookup tables in the FE can lead to
unnecessary mass updates.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Friday, February 20, 2009 2:06 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Find First in an Array?

" I am not going to get into the "this is a local table so it goes in
the
FE... oh damn, now I gotta go update the data in 5 different FEs".  BEs
are
for data (in my world)."

In my case, where the 'data' is really static, and is needed by each
user,
wouldn't the design be better with the language tables in the FE?


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list