Re: [PHP] Re: the opposite of a join?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!
...........................................................

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux