Paul DuBois [mailto:[EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
