subject:"Fastest query \?"

Re: Fastest query ?

2001-05-21 Thread Joshua Chamas

Jocelyn Fournier wrote: > > Hi, > > I wonder which of the following queries is faster : > > $result=mysql_query("SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1"); > > or : > > $max=mysql_query("SELECT max(date) FROM forum"); > list($max)=mysql_fetch_row($max); > $result=mysql_query("

Fastest query ?

2001-05-21 Thread Jocelyn Fournier

Hi, I wonder which of the following queries is faster : $result=mysql_query("SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1"); or : $max=mysql_query("SELECT max(date) FROM forum"); list($max)=mysql_fetch_row($max); $result=mysql_query("SELECT lastauteur FROM forum WHERE date='max'");