Re: Design / Implementation problem - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Design / Implementation problem
Date
Msg-id 87slc2y667.fsf@gmail.com
Whole thread Raw
In response to Design / Implementation problem  (Naz Gassiep <naz@mira.net>)
List pgsql-general
Naz Gassiep <naz@mira.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@gmail.com>

pgsql-general by date:

Previous
From: Naz Gassiep
Date:
Subject: Re: Design / Implementation problem
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: plperl question: how to specifiy perl version?