开发者

Oracle Client vs ODP.NET is ASP.NET Application

We've developed an ASP.net application using Oracle Client for database connection,

Our application is running on Windows Server 2003 server

Now we want to move to Windows Server 2008 server and change the driver to ODP.NET,

I have noticed using some loadtest, that with ODP.NET, the application consumes more memory than with Oracle Client, for a test with 230 users and Oracle client the average memory used is 793 MB

With ODP.NET, for the same loadtest configuration, the average memory used is 871 MB

My question is why with ODP.NET we consume more memory than with Oracle Client?

Some search on the Internet indicates that OD开发者_运维问答P.NET puts the schema information in the cache, can you confirm that?

Oracle version : 11.2.0


Technical Comparison: ODP.NET Versus Microsoft OracleClient

...the schema information in the cache,

It is not listed but it does cache your statement.

...many of the classes in the System.Data.OracleClient namespace are marked as obsolete. Microsoft no longer is going to keep working on them in the future.

and from this post, it says that microsoft won't maintaining the driver anymore.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜