Re: Queues Problem

From: uaca man <uacaman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Queues Problem
Date: 2010-06-08 20:40:34
Message-ID: AANLkTimvr_P6JHAU3eMjSK7ZjVkPkBR90BQjBS9yN1Jo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/6/8 Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com>

> On Tue, Jun 8, 2010 at 1:26 PM, uaca man <uacaman(at)gmail(dot)com> wrote:
> >> 2) Think of the front end as changing states as the user interacts
> >> with it, then figure out what queries need to be made to correspond to
> >> the changes in state. For example, it is unlikely the user needs the
> >> amount of "gold" updated every 5 seconds. Rather, they need to know
> >> how much they have on hand when they go to use it. At that point, you
> >> query for the old balance, find the last updated time, how many
> >> buildings have been completed since then and for how long and figure
> >> out what the new gold balance is. Update the new balance at that
> >> point (with a timestamp), and the front end goes on it's merry way...
> >
> > That is exactly what we are doing for the most part and was our first bet
> > with the buildings, however since building can affect pretty much
> anything,
> > anywhere on the game changing states as the user interacts is getting
> beyond
> > comprehension of a human mind(al least for my mind) and that was when I
> had
> > the super idea, lest put the queue on the crontab!
>
> Then each thing the building interacts with has it's own unique set of
> states. The only ones you need worry about are the ones a _user_ is
> actually interacting with at any given point.
>
> >
> > Looks like we are going to cut off a few options of the game.
> > ps: do i top post or bottom post here?
> >
>
> I guess that there is no easy solution, will try the first bet and
> calculate the past every user request.
>

> --
> Peter Hunsberger
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aleksey Tsalolikhin 2010-06-08 20:51:16 Re: Postgres 8.4 segfaults on CentOS 5.5 (using EnterpriseDB installers)
Previous Message Andrew Geery 2010-06-08 20:27:07 full-text search configuration question