Fetch size in Oracle Provider for OLE DB

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

Fetchsize

Fetchsize determines the number of rows that will be fetched at a given amount of time. The fetch size should be set accordingly. To implement the fetchsize use the following command.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;FetchSize=200;

NOTE: The default value for fetchsize 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.