Performances problem with delphi 6.0

[ROLF]

Hello,

I'm converting and application from delphi 3 to delphi 6 (upd pack 1), I use DOA 3.4.5 and ORACLE 8.5.0 database , with delphi 3 all works fine and is very performant.
With delphi 6.0 using the TOracleDataSet component (only this , TOracleQuery works fine) at the first execution take more or less 33 time more that the first execution with delphi 3 using the same query and configuration for Oraclesession ( It take 1 second insted of 0,03).
Are there some particular configuration to do using delphi 6.0

------------------
Thanks & Ciao
Raffaele

 

[Marco Kalter]

The Delphi 6 version should do exactly the same as the Delphi 3 version. For these dramatic performance differences I can only assume that the queries are different or some other TOracleDataSet property is different (QueryAllRecords is one of the usual suspects).

You can use the Oracle Monitor utility to find out what exactly the difference is.

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

 

[RRA]

Many thanks,

I have debugged the doa component and I see that the problem occours when I create dinamically a TOracledataset and delphi 6.0 notify the creation of the Tfield.
When I add at design time the needed fields the problem doesn't occours and the performances are fine.
To solve the problem I create dinamically the needed field in a my component devived from TOracledataset.

Haven't you find something like this ?
Do you have another idea ?

Hi Rolf

[This message has been edited by RRA (edited 07 February 2002).]