> Thank you for your time ...
>
> I will do some serious reading and testing !

And make your life easier by using some kind of monitoring/tracing
stuff, which actually shows you what's really happening behind the
scene. In one occasion, when tracing a third-party application, an
implementation of an assumed "simple" business use-case produced a *lot*
of DML operations combined with unparametrized DML statements etc. A
use-case which was processed by a lot of people, many times per day.
According to the monitoring output, the developers optimized that and
things are much better now. The Trace API is a godsend here.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/