Naz Gassiep <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend