Re: LookUp TABLE(s)

Roy Wagner (roywagner_at_aol.com) wrote:
: From your experience (of from something you have read), for a
: Client/Server application, would it be better to have 10 small similar
: lookup tables or ONE large table with a flag column to get the proper
: records. Note that if one table were used, not all the columns would
: contain data, some columns would be specific based on the flag values.
 

: Thanks.

Roy -
I have seen this done both ways. My personal preference is to make seperate tables. When you lump them together, then you might end up with a huge pile of reference records that you need to look through and maintain even though you are only really trying to pick one of two or three rows. If they all are small enough, you probably won't notice the performance hit but I like to keep it clean.

Randy :)

--
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I