Fetch size in Oracle Provider for OLE DB
This article deals with connection string related to Fetch size in Oracle Provider for OLE DB.
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