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
rk, I'd be interested to see how you did it.
--Michael
-Original Message-
From: Tom O'Neill (MySQL User) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:09 PM
To: [EMAIL PROTECTED]
Subject: SELECT SPEEDS..
Is there any difference in speed between the followin
BENCHMARK command.
--Michael
> -Original Message-
> From: Tom O'Neill (MySQL User) [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 1:09 PM
> To: [EMAIL PROTECTED]
> Subject: SELECT SPEEDS..
>
>
> Is there any difference in speed between the f
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
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)
