On Wed, Aug 20, 2003 at 03:08:59PM -0500, Tom O'Neill (MySQL User) wrote:
> Is there any difference in speed between the following select statements?
>
> SELECT yada,yda FROM test WHERE id IN(1,2,3)
>
> OR
>
> SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id =3)
Often times, no.
But it
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(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
>> >
>> >And com
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(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
> >
> >And compare to
> >
> >BENCHMARK(10, SELECT yada,yda FROM test WHERE
At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
This is trivial to benchmark yourself. Try:
BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
And compare to
BENCHMARK(10, SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id
=3))
See http://www.mysql.com/doc/en/Miscellane
This is trivial to benchmark yourself. Try:
BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
And compare to
BENCHMARK(10, 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 BENCH
On 20 Aug 2003 at 15:08, Tom O'Neill (MySQL User) wrote:
> Is there any difference in speed between the following select
> statements?
>
> SELECT yada,yda FROM test WHERE id IN(1,2,3)
>
> OR
>
> SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id =3)
You can put EXPLAIN in front of your S