Performance problems with OraDirect.NET Provider

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
ChrisW
Posts: 1
Joined: Thu 13 Oct 2005 14:48

Performance problems with OraDirect.NET Provider

Post by 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

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by 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.

Post Reply