SV: [firebird-support] general question: calculated fileds vs performance

2015-07-07 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
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

[firebird-support] Problem occuers while trying to generate trace file

2015-07-07 Thread babak_...@yahoo.com [firebird-support]
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

[firebird-support] Re: general question: calculated fileds vs performance

2015-07-07 Thread brucedickin...@wp.pl [firebird-support]
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.