it doesnt work i tried it, case of follow the sheep :D > 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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]