[AccessD] Lookup Fields in Table Design

DWUTKA at marlow.com DWUTKA at marlow.com
Fri Mar 26 14:56:23 CST 2004


I honestly don't know until testing it a lot, because like we both are
saying, if it's only increase in size, due to the indexing space
requirements, that the cost of a feature...yippie, and it's not much at
that!  However, if over time, you get small amounts used in temporary space,
I still think it's a moot point on that, but it would technically be bloat.
Not much though.  Not like making massive temp tables, to show a report,
instead of querying the data the right way.  THAT, to me, is bloat.  The
querries might use a little space, but I always thought that JET kept that
stuff out of the database.....no Mountain Dew at work right now though, so
my brain is running low on caffiene, may be just making that part up! LOL

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Friday, March 26, 2004 1:57 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Lookup Fields in Table Design



VERY interesting.  Have to give them half a point back, because there is a
small amount of 'bloat', if you use a query/table for the lookup.  But it's
negligible, and also, both databases grow when you index the field, just
grows a bit more.  I would never really call that 'bloat'.  Not trying to
back track, but to me, bloat is when a database grows in size over time, but
when compacted, it gets smaller.  The portion that is 'reduced' is bloat.
The portion left after the compact is 'overhead'.  That's my definition.
Admittedly, if you are going to run close to max db size, then lookups
should be removed, to get that much more space.  But we are talking overhead
space, not really 'bloat'.

==============Wait!!!!!!!!!!! Is it true bloat, or just normal increase due
to feature use. I mean, if you use it,  it's going to cost something
somewhere. So don't be so quick to label it -- but if it really bloat, then
OK. :) 

Susan H. 

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list