Hello! Generally speaking, regarding performance, is expensive having
calculated fields?
Not complex ones, I mean this type of thing:
... COMPUTED BY (cast(qty * price * tax / 100 as money 2))
So far I don't notice any difference but I'd like to hear opinions about
whether is a good
idea
Hi experts
I would like to trace data base activity in fire bird using Audit/Trace
Services. I run this command in my command prompt:
C:\Program Files\Firebird\Firebird_2_5\binfbtracemgr -se
localhost/3050:service_mgr -user SYSDBA -password masterkey -start -name User
Trace 1 -config
If you do not notice any performance then do not worry ahead.
In case of any performance degradation you will easily switch to persistent
column with trigger on INSERT/UPDATE.