On Sun, Jan 27, 2013 at 9:25 AM, Alexander Farber <[email protected]> wrote: > Hello - > > On Fri, Jan 25, 2013 at 7:42 PM, Jeff Janes <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
