> 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/
