When oracleCommand.FetchSize=0, a value of FetchSize will be determined automatically (for better performance) and it will be changed dynamically when executing read operations.
The least amount of memory consumed with oracleCommand.FetchSize=1.
For more information about the FetchSize property, refer to https://www.devart.com/dotconnect/oracl ... hSize.html.
Memory usage for OracleDataReader
Re: Memory usage for OracleDataReader
Hi,
I know the meaning of property 'FetchSize', and I wonder is there any other property or method which can help reducing the memory usage when FetchSize = 0 ?
I know the meaning of property 'FetchSize', and I wonder is there any other property or method which can help reducing the memory usage when FetchSize = 0 ?
Re: Memory usage for OracleDataReader
There is no any other property. Please set FetchSize to some fixed value (1 or greater).jizhu233 wrote:I wonder is there any other property or method which can help reducing the memory usage when FetchSize = 0 ?
Re: Memory usage for OracleDataReader
Hi,
Is there any new finding or suggestions about this problem?
Is there any new finding or suggestions about this problem?
Re: Memory usage for OracleDataReader
We will implement the Default Fetch Size connection string parameter (corresponds to oracleCommand.FetchSize) in the next public build and notify you when it is available for download.
Does Fetch Size setting solve the memory usage issue you have encountered?
Does Fetch Size setting solve the memory usage issue you have encountered?