Re: Re: the opposite of a join?
| From: | Robert Cummings | Date: | Thu, 04 Oct 2007 01:09:02 +0000 |
| Subject: | Re: Re: the opposite of a join? | ||
| References: | 1 2 3 4 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-44127@lists.php.net to get a copy of this message | ||
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.
> So, if I was running MySQL, I would use SQL #1, but if I were using PostgreSQL, I would use SQL
> #2
I'd use the left join whenever available.
Cheers,
Rob.
--
...........................................................
SwarmBuy.com - http://www.swarmbuy.com
Leveraging the buying power of the masses!
...........................................................