[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Lookup tables
From:       "Perrin Harkins" <perrin () elem ! com>
Date:       2008-07-31 17:57:07
Message-ID: 66887a3d0807311057x4041aafcg713b039442ed1cc2 () mail ! gmail ! com
[Download RAW message or body]

On Thu, Jul 31, 2008 at 12:59 PM, Chris W <2wsxdr5@cox.net> wrote:
> So my question is, is doing that way better than making the query more
> complex with all the joins?

If by "better" you mean "faster" then yes, it probably is marginally
faster.  It would be simpler to just use the actual values you want in
the lookup columns rather than integers.  It might slow down writes a
little (since the foreign key lookup would be a string instead of an
integer) but it eliminates joins for reading.  The downside is
duplicated data.

- Perrin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]