Page 1 of 1

Performance problems with OraDirect.NET Provider

Posted: Thu 13 Oct 2005 14:56
by ChrisW
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

Posted: Thu 13 Oct 2005 15:20
by Paul
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.