InitialLOBFetchSize & FetchSize."oracle" [message #356036] |
Wed, 29 October 2008 02:14 |
startanew
Messages: 6 Registered: October 2008
|
Junior Member |
|
|
Hi guys,
There seems to be alot of explanation on both the oracle property in the oracleCommand object. But non does clearly explain the usage in the real life situation
Let say i have a table :
Table : Customer
Field : Name varchar(255)
Filed : Address (Blob/Lob)
when retrieving the whole data in customer table it will use FetchSize to determine each round of data retrieval.
The question is, when i set the FetchSize do i need to consider the initiallobfetzhsize ? Since initiallobfetchsize determine how big oracle will fetch the blob/lob (e.g. Address)
How you guys understand my query.
Thank you in advance.
|
|
|
|
|