List:General Discussion« Previous MessageNext Message »
From:Michael S. Fischer Date:August 21 2003 2:21am
Subject:RE: SELECT SPEEDS......
View as plain text  
Paul DuBois [mailto:paul@stripped] writes:

> At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
> >This is trivial to benchmark yourself.  Try:
> >
> >BENCHMARK(100000, SELECT yada, yada FROM test WHERE id IN(1,2,3))
> >
> >And compare to
> >
> >BENCHMARK(100000, SELECT yada,yda FROM test WHERE (id =1 or 
> id = 2 or 
> >id
> >=3))
> >
> >See http://www.mysql.com/doc/en/Miscellaneous_functions.html for 
> >documentation on the BENCHMARK command.
> 
> BENCHMARK() is a function, not a command.  The syntax you 
> suggest will not work.  It expects an expression as the 
> second argument, not a SELECT statement.
> 
> That's my understanding, anyway.  If you've been able to make 
> that work, I'd be interested to see how you did it.

I stand corrected.

--Michael

Thread
SELECT SPEEDS......Tom O'Neill \(MySQL User\)21 Aug
  • Re: SELECT SPEEDS......Keith C. Ivey21 Aug
  • RE: SELECT SPEEDS......Michael S. Fischer21 Aug
    • RE: SELECT SPEEDS......Paul DuBois21 Aug
      • RE: SELECT SPEEDS......Michael S. Fischer21 Aug
        • RE: SELECT SPEEDS......daniel21 Aug
  • Re: SELECT SPEEDS......Jeremy Zawodny21 Aug