Re: Design / Implementation problem

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: Naz Gassiep <naz(at)mira(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Design / Implementation problem
Date: 2007-03-18 14:31:28
Message-ID: 87slc2y667.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Naz Gassiep <naz(at)mira(dot)net> writes:

> that calculating the point
> balance on the fly is not an unfeasibly heavy duty calculation to be done at
> every page view?

One alternative to calculate it everytime is calculating it once a day. If
there are calculations for today, then just read the calculated value.
Otherwise calculate it.

If the user earns more points, make an entry at the raw table (for the
expiration process) and increments today points. Do the same for points
spent.

--
Jorge Godoy <jgodoy(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-03-18 15:02:24 Re: cannot get build (initdb) to work after trying for a week
Previous Message Naz Gassiep 2007-03-18 13:45:16 Re: Design / Implementation problem