Re: Optimizing select count query which often takes over 10 seconds

Hello Kevin,

On Wed, Jan 30, 2013 at 12:09 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
> Alexander Farber <alexander.farber@gmail.com> wrote:
>
>> update pref_users set medals = 0;
>> UPDATE 223456
>
> You're probably going to like your performance a lot better if you
> modify that to:
>
> update pref_users set medals = 0 where medals <> 0;

is it really so?

I only have 65 users (out of 223456) with medals != 0.

When programming other languages, I never do
if (x != 0) { x = 0; } but just set x = 0 straight away.

Regards
Alex