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! ........................................................... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
