Performance problems with OraDirect.NET Provider

Performance problems with OraDirect.NET Provider

Postby ChrisW » Thu 13 Oct 2005 14:56

Today we bought the OraDirect.NET Provider, because we had some Problems with Microsofts OracleClient (Character Set issuses)!
But now we get performance loss when executing more Selects and stored procedures!

For example:
(MS) OracleClient takes 4600ms on first run, second run 970ms
OraDirect.NET takes 5900ms on first run, second run 3000ms!
OLEDB takes 5900ms on first run, second run 1600ms!

Can we set something to get better performance??

Thanks
Chris
ChrisW
 
Posts: 1
Joined: Thu 13 Oct 2005 14:48

Postby Paul » Thu 13 Oct 2005 15:20

Do you use Direct connection or connection through OCI?
Send us please small demo project to demonstrate the problem and include script to create server objects.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle