mysql 3 table join

[eluser]hvalente13[/eluser]
Hi,

It's just a suggestion:

I only make joins for small tables (ex: employees table and join to gender table, position table, etc...).

For other tables that have a lot of rows, I make separate queries (ex: zip codes)...

I've read this some place, that it gives more performance to database queries... I tested it and got some improvement.

Give it a try.