On Sun, Jan 27, 2013 at 9:25 AM, Alexander Farber <alexander.farber@xxxxxxxxx> wrote: > Hello - > > On Fri, Jan 25, 2013 at 7:42 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: >> 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. Once the week is over, materialize the medals for that week. Then the live part of the query only needs to specify the currently live week, not the entire history. And in that case, the query should be quite efficient if you have in index on both week and money. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
