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
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
