TalkPHP - View Single Post

CoryMathews · 06-30-2009, 02:18 PM

I think you need to change the design of your database. Take a step back and ask yourself.

What tables can I merge and what tables can I get rid of?

If you database is no longer 100% 3nf who cares. You should not have to do 2 joins in a single query. You really want to avoid as many joins as possible as they will slow down your querys a greay deal once the database gets some size to it.

06-30-2009, 02:18 PM	#2 (permalink)
CoryMathews The Addict Join Date: Nov 2007 Location: USA Posts: 258 Thanks: 7	I think you need to change the design of your database. Take a step back and ask yourself. What tables can I merge and what tables can I get rid of? If you database is no longer 100% 3nf who cares. You should not have to do 2 joins in a single query. You really want to avoid as many joins as possible as they will slow down your querys a greay deal once the database gets some size to it. __________________ osGuide.net - Free and Open Source Software \| CoryMathews Lastest Blog Post: Saving a PHP File as a Word Document