Chunk size in Oracle Provider for OLE DB
This article deals with connection string related to chunk size in Oracle Provider for OLE DB.
Chunk size is basically a one or more than one oracle blocks containing code. The command given below is used for specifying the size of the data that should be fetched and stored and stored in the cache. More the chunk size better will be the performance but will require extra memory space.
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;ChunkSize=200;
NOTE: The default value for chunk size is 100.
You may also want to read these related articles.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here