RE: [PHP] PHP/mySQL question about groups

2008-02-07 Thread Warren Vail
6 AM > To: PHP General list > Subject: Re: [PHP] PHP/mySQL question about groups > > On Feb 7, 2008 1:20 AM, Warren Vail <[EMAIL PROTECTED]> wrote: > > I did some looking into performance issues many years ago at company > that > > developed and marketed another databas

Re: [PHP] PHP/mySQL question about groups

2008-02-07 Thread Andrew Ballard
On Feb 7, 2008 1:20 AM, Warren Vail <[EMAIL PROTECTED]> wrote: > I did some looking into performance issues many years ago at company that > developed and marketed another database server, comparing the query plan to > the actual code, and a query plan usually shows the processes that consume > the

RE: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Warren Vail
Vail -Original Message- From: Andrew Ballard [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 8:41 PM To: PHP General list Subject: Re: [PHP] PHP/mySQL question about groups On Feb 6, 2008 11:20 PM, Nathan Nobbe <[EMAIL PROTECTED]> wrote: > On Feb 6, 2008 10:59 PM,

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Andrew Ballard
On Feb 6, 2008 11:20 PM, Nathan Nobbe <[EMAIL PROTECTED]> wrote: > On Feb 6, 2008 10:59 PM, Andrew Ballard <[EMAIL PROTECTED]> wrote: > > > Of course, in this case you could just avoid all the confusion with > > this statement as well: > > > > SELECT DISTINCT name, size > > FROMwine > > im not

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Nathan Nobbe
On Feb 6, 2008 10:59 PM, Andrew Ballard <[EMAIL PROTECTED]> wrote: > Of course, in this case you could just avoid all the confusion with > this statement as well: > > SELECT DISTINCT name, size > FROMwine im not sure why, but i think distinct is typically way slower than group by. -nathan

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Andrew Ballard
On Feb 6, 2008 8:46 PM, Rob Gould <[EMAIL PROTECTED]> wrote: > Let's say I have a PHP-based wine application, and it's taking a set of mySQL > data that looks like this: > > wineidname > size > 123 Sil

RE: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Bastien Koert
Select * from wine where name = 'Silver Oak' GROUP BY wineid,size bastien> Date: Wed, 6 Feb 2008 17:46:52 -0800> From: [EMAIL PROTECTED]> To: php-general@lists.php.net> Subject: [PHP] PHP/mySQL question about groups> > Let's say I have a PHP-based wine application, and it's taking a set of m

Re: [PHP] PHP/mySQL question about groups

2008-02-06 Thread Nathan Nobbe
On Feb 6, 2008 8:46 PM, Rob Gould <[EMAIL PROTECTED]> wrote: > Let's say I have a PHP-based wine application, and it's taking a set of > mySQL data that looks like this: > > wineidname > size > 123 Silver Oak > 750ML > 123