On 29/04/15 21:40, shg_siste...@yahoo.com.ar [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
