Memory usage for OracleDataReader

Re: Memory usage for OracleDataReader

Postby Shalex » Wed 22 Jun 2016 15:11

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/oracle/docs/?Devart.Data.Oracle~Devart.Data.Oracle.OracleCommand~FetchSize.html.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Re: Memory usage for OracleDataReader

Postby jizhu233 » Mon 10 Oct 2016 09:12

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 ?
jizhu233
 
Posts: 10
Joined: Wed 11 May 2016 02:18

Re: Memory usage for OracleDataReader

Postby Shalex » Wed 12 Oct 2016 11:04

jizhu233 wrote:I wonder is there any other property or method which can help reducing the memory usage when FetchSize = 0 ?
There is no any other property. Please set FetchSize to some fixed value (1 or greater).
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Re: Memory usage for OracleDataReader

Postby jizhu233 » Thu 16 Mar 2017 09:24

Hi,
Is there any new finding or suggestions about this problem?
jizhu233
 
Posts: 10
Joined: Wed 11 May 2016 02:18

Re: Memory usage for OracleDataReader

Postby Shalex » Wed 22 Mar 2017 16:27

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?
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Previous

Return to dotConnect for Oracle