DOA performance

[iansmith]

We are running a distributed delphi 5 client server over 3 machines (2 application servers per machine). We have heard that DOA will give us perfomance gains over network communication and sql query time against the BDE. Having run prolonged tests we have found that the default settings give us a gain of only 1.5%.
We are interested to know what changes we must make in order to achieve some of the gains quoted on this site.
The test setup used Oracle 8.1.7.4 on a separate server, a 100Megabit switch, all machines dual pentium III 1.4Ghz . The application servers are mainly insert and select based queryies using TOracleQuery. The selects generally return only a few rows.
Any information greatly appreciated.

 

[Marco Kalter]

Some performance hints:

[*] Do not close TOracleQuery instances, so that they do not need reparsing when subsequently executed for the same SQL.

[*] Set TOracleQuery.ReadBuffer to an optimal value. For queries that return less than 25 records the default is okay. For queries that return up to 100 records, set it to 100. Higher values will not improve performance much, but you can always fine-tune this.

[*] Use Array DML if you execute multiple inserts simultaneously.[/list]
If this doesn't help, then maybe the performance bottleneck for the applation is not the database access, but some other application processing.

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