Hello Kevin,
On Wed, Jan 30, 2013 at 12:09 AM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote:
> Alexander Farber <alexander.farber@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
