[AccessD] Find First in an Array?

ROTFL.

Who is this "great John Colby" guy?  Sounds like a magician or escape artist or something.

When I think about "static data tables in the FE" (which isn't often!) I always thought of it in the 
"list table" context.  Colors, gender, state, etc.  My applications have so many list tables that it 
makes no sense TO ME to get into a "this one should, this one shouldn't" kind of thing.  I just 
leave all such tables in the BE.  I have enough things to think about without spending time on stuff 
like that.  If the table doesn't change much but impacts performance I cache it.  Otherwise I don't. 
   I mean think about it, "list tables in the FE" are a cache of sorts, you are "caching" them in 
your FE on your local hard disk.

My problem with the concept is simply spending time on evaluating the "content change" issue for 
each table.  Obviously you can't cache (for example) a city table in the FE if the user can add 
cities on a daily basis.  The state table OTOH probably never has records added.  So you spend time 
trying to think about which should and which shouldn't.  Get it wrong and the database starts to 
break.  Basically any table in the FE simply cannot be updated by users.

Bahhh.  Data belongs in the BE, not on my desk making case by case decisions.

Having said that, our good friend Jürgen Welz has an application where caching everything he could 
in the FE made perfect sense.  His FEs had to work over very slow lines, over the internet IIRC and 
every byte of data transferred over the wire mattered.  My clients OTOH don't do that so I just made 
a decision to spend my time on other things.

I truly have never run into tables that were so FE specific and had ancillary reasons (sending out 
for translation) to have them in the FE.

Anyway... glad I could light up your day.  8~)

John W. Colby
www.ColbyConsulting.com


Jennifer Gross wrote:
> Wow, to sway the great John Colby.  And in a "religious" argument no
> less.  Now that made my day.
> 
> Seriously smiling,
> 
> Jennifer
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Friday, February 20, 2009 1:05 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Find First in an Array?
> 
> 
> Now there is a reason that places the whole issue in a new light.
> Language data is indeed specific 
> to a particular FE in a way that most other data is not.  So perhaps for
> that specific task, a table 
> in the FE makes perfect since.  I would STILL cache it but that is
> another issue.
> 
> Thanks Jennifer,
> 
> John W. Colby
> www.ColbyConsulting.com