On Thu, Mar 19, 2009 at 8:42 AM, Anton V. Belyaev
wrote:
> I have 4-cored machine, so I expected the query to be able to run for
> a long time without performance degrade for application.
As Bill mentioned, this won't help a bit if you've got a slow / dodgy
/ overloaded IO subsystem. What does
In response to "Anton V. Belyaev" :
> Hello,
>
> I want to run a long running query in background to collect
> statistics. I.e. how many users played the game last month more than
> 50 times.
>
> SELECT count(*) FROM (SELECT user_id, COUNT(*) AS total_games FROM
> games, game2user WHERE games.fi
Hello,
I want to run a long running query in background to collect
statistics. I.e. how many users played the game last month more than
50 times.
SELECT count(*) FROM (SELECT user_id, COUNT(*) AS total_games FROM
games, game2user WHERE games.finished > '2009-02-19' AND games.id =
game2user.game_i
