On Thu, Jul 31, 2008 at 12:59 PM, Chris W <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]