Posted by Stefan Rybacki on 09/28/48 11:32

Rik wrote:
> Stefan Rybacki wrote:
>...
> Could be done, but keeping calculated fields permanent in your db is (most
> of the time) bad db-building and/or a waste of space.

No it isn't. This is what views are made for.

> I'm curious why you'd
> want to have this calculated field in your db in the first place?

An example for "permanent" (in a view) is for example a price and the discount on it.
Views can really speed up things and also keep your data consistent.

Regards
Stefan

>
> Grtz,
>
> Rik
>
>

[Back to original message]