Preparing Queries

[iansmith]

We have heard DOA does not follow the concept of the BDE in preparing queries. Is this true and if so is there a work around as the BDE performance is much faster using a prepared query.

 

[Marco Kalter]

In Direct Oracle Access this is implicitly done if you set Optimize to True (the default value), and do not close TOracleQuery instances between executions. For the second and subsequent executions it will reuse the parsed representation of the SQL.

------------------
Marco Kalter
Allround Automations