Subject Re: [firebird-support] performance on calculated fields - performance question
Author Lester Caine
On 29/04/15 21:40, shg_sistemas@... [firebird-support] wrote:
> With 40.000 records, I have no problem with this. But do you think it
> will be very bad as the customers keep growing?
> I mean, generally speaking, it's "expensive" (regarding to the speed) to
> have calculated fields??

The calculated fields don't actually exist in the database. They are
created when a record is accessed. What would be better in your case is
to create the calculated field in a trigger and add it to the record.
That way the data can be indexed and searched like any other field.

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Rainbow Digital Media -