Chunk size in Oracle Provider for OLE DB

This article deals with connection string related to chunk size in Oracle Provider for OLE DB.
  • 2553

Chunksize

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.

Further Readings

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.