[DUG] Firebird connections / queries

[Robert martin]

>Similarly is it OK to prepare queries when the app starts and leave them in
>a prepared state for extended periods?
>
>  
>
My understanding of Firebird is that preparing a query takes up 
resources on the Server, so preparing queries will use resources.  So it 
is bad in one respect.  However my 'guess' is that if you have plenty of 
resources and a limited number of prepared querys that are used 
regularly, that it is probably better to use the resources then 
continuously re prepare queries.

That is my guess :)

Rob Martin
Software Engineer

phone +64 03 377 0495
fax   +64 03 377 0496
web www.chreos.com

Wild Software Ltd