Models Remember Vars?

[eluser]JoostV[/eluser]
Calculating on-the-fly is more expensive, true. But if you leave the calculation to MySQL it's very fast indeed, and even PHP calcualtion will be very fast. Also, you could cache the page.

But it's a trade-off, really. It's just that for scaling purposes this looped query could cause a time-out and thus a corrupted database, with some records having been recalculated, and some not.

I'm not a MySQL guru, but there might also be a way to replace the looped queries with a single caculation query that will update all record at once. Don't ask me how, though...