Subject | Re: Table "computed by" or view calculation? |
---|---|
Author | Adam |
Post date | 2007-08-10T22:32:47Z |
--- In firebird-support@yahoogroups.com, "Jorge Andres Brugger"
<jorge.brugger@...> wrote:
Adam
<jorge.brugger@...> wrote:
>performance,
> I'm writing a view that include some calculations. In terms of
> and generally talking, what is better?I would be extremely surprised if there was any difference.
> - Create a "computed by" field in table, and reference it from view, or
> - Do calculation directly in the view (price * qty AS Total)
>
Adam