Hello - On Fri, Jan 25, 2013 at 7:42 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > On Thu, Jan 24, 2013 at 1:57 AM, Alexander Farber > <alexander.far...@gmail.com> wrote: >> >> LOG: duration: 12590.394 ms statement: >> select count(id) from ( >> select id, >> row_number() over(partition by yw order by money >> desc) as ranking >> from pref_money >> ) x >> where x.ranking = 1 and id='OK471018960997' > > This sounds like a good idea. But if the tournament is weekly why > would the job have to be hourly? Why do the results of a weekly > tournament need to be 'live'?
because for the current week the medals are displayed too. And when a player enters a top then he should get +1 medals and the one he pushed from the top -1 medals So even hourly isn't really good enough for me... It should be "live" stats. Regards Alex -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
