Re: Re: the opposite of a join?
| From: | Robert Cummings | Date: | Thu, 04 Oct 2007 01:38:24 +0000 |
| Subject: | Re: Re: the opposite of a join? | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-262722@lists.php.net to get a copy of this message | ||
On Thu, 2007-10-04 at 11:23 +1000, Chris wrote:
> 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 ;)
Yes, but you're not going to get a performance improvement if you use
anything else if the table isn't properly indexed.
Cheers,
Rob.
--
...........................................................
SwarmBuy.com - http://www.swarmbuy.com
Leveraging the buying power of the masses!
...........................................................