Does .NET Framework Data Provider for Oracle also have a CacheType feature like OraOLEDB?

[Sunil Menon]

Dear All,
Does MS supplied .NET Framework Data Provider for Oracle also have
a CacheType feature like OraOLEDB?
Also if the value is set to file where is the file stored? on the DB
server or on the client?
Here is the description:
OraOLEDB-specific connection string attributes which affect the
performance of the
rowset are:
¦ CacheType - specifies the type of caching used by the provider to
store rowset
data. OraOLEDB provides two caching mechanisms:
¦ Memory - The provider stores all the rowset data in-memory. This
caching
mechanism provides better performance at the expense of higher memory
utilization. The default is Memory.
¦ File - The provider stores all the rowset data on disk. This
caching mechanism
limits memory consumption at the expense of performance.


Please help...

Thanks & regards
Sunil

 

[Guest]

Not sure about the 2.0 implementation, but no on the 1.x implementation. It
was originally created against 8i, if I remember correctly and contains
pretty base functionality.

ODP.NET, from Oracle, is a more complete provider. Consider moving to it if
you are getting into more advanced functionality.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************