Executing a TOracleDataSet

[stef]

Hi,

I have performance problem with a TOracleDataSet (CBuilder 5, DOA 4.1)Win-7;

When I'm using the TQuery Component there is no problem, but in WINDOWS-7 the same Query is executing a lot of slower (1sec TQuery; more then 20sec with TOracleDataSet) then in Windows-XP.

Does somebody have an idea to get a finger on this problem.

What I did:
Removed the DataSet to the Grid
Installed the latest Version DOA 4.1

Create a second call with TQuery
This is working much faster???

Br,

 

[Marco Kalter]

What happens if you remove the TDataSources and event handlers from the TOracleDataSet? This way you can see if the query itself is slow, or some processing or controls on the client side.

 

[stef]

Nothing, the performance is still bad

Is there a way that we can monitor the query call.
Or does this only work for a different Version.

I get the message you need to have the proper version installed

 

[stef]

Temp we fixed it now with the following code

Memo1->Text = Q_Get_Pos->SQL->Text ;
Q_Get_Pos->SQL->Clear();
Q_Get_Pos->SQL->Add( Memo1->Text);

Really don't know why this is working better ????

 

[Marco Kalter]

To monitor the differences you can use the Oracle Monitor tool. It will show all database activity (execute select, fetch records, and so on).

 

[stef]

Marco,

Is there somewhere an old Version form OracleMonitor, we have only the new version, and unfortunately this version does not work with Builder 5

The strange things is also that this problem is not happening all the time!!#$%

thx

 

[Marco Kalter]

You can download version 2.1, 2.0, or 1.0.