OracleLoader.BufferSize guidelines?

[Dennis Wanke]

Are there any guidelines regarding the values of OracleLoader.BufferSize property? For instance, how it affects the loading process in terms of performance and so on.

[Pinturiccio]

OracleLoader.BufferSize - influences the amount of data OracleLoader sends to the database at once. If you load big volumes of data, more than one database call may occur. The more you increase BufferSize, the better performance you get, however, the more memory the load operation will require.

For more information, please refer to http://www.devart.com/dotconnect/oracle ... rSize.html

[Dennis Wanke]

OK, I see. On my system, the property has a default value of 262144 (256K) - is it hard-coded or set somehow dynamically? Why such a small size is chosen as a default? Do you see any complications of setting the size to, say, 10 MB? And to 100 MB? What about 1 GB? Are you aware of any complications, e.g. with Oracle transfer protocols, or the like? Does the value affect performance linearly or is there any reasonable size limit after that no significant performance gain is more observed?

[Pinturiccio]

Yes, the BufferSize property has the default value 262144 (256K). dotConnect for Oracle supports old Oracle versions such as Oracle 8 and Oracle 7.3, so we can't change the default value for the BufferSize property. If you want to use larger BufferSize, then you have to change its value manually.