Re: Re: the opposite of a join?

From: Date: Thu, 04 Oct 2007 01:23:49 +0000
Subject: Re: Re: the opposite of a join?
References: 1 2 3 4 5  Groups: php.db php.general 
Request: Send a blank email to php-db+get-44128@lists.php.net to get a copy of this message
Robert Cummings wrote:
On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote:
This is only from my own personal testing. Mind you that I have only been using PostgreSQL for a year or so. But one problem that I have always ran into with MySQL is that when JOIN'ing tables that have large data sets is a PITA.
Were you doing left joins when you experienced those problems? Left joins are usually very fast.
If indexed properly of course ;) -- Postgresql & php tutorials http://www.designmagick.com/

« previous php.db (#44128) next »