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 - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk