locked
OracleDataReader.GetBytes recommended byte length? RRS feed

  • Question

  • User1000638852 posted

    I am upgrading a legacy app that uses OracleDataReader.GetBytes() to retrieve file blobs from a db.

    (msdn method definition: https://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracledatareader.getbytes(v=vs.110).aspx)

    The last input param is the size of the byte blocks innumerated for a BinaryWriter.

    In legacy app, this last param is set to 8096 with a comment from 2004.

    Given this setting from 2004, I'm wondering how much higher I can set this since the new app is being deployed to 2008 Servers with an eye on performance.

    Can someone give me some suggestions and considerations? Much appreciated.

    Tuesday, June 23, 2015 10:10 AM

Answers

  • User-84896714 posted

    Hi jjmonty,
    Thank you for your post.
    The length is size of buffer block.
    Whether it is bigger or smaller will not have a significant impact on the performance of the application.
    So just leave 8096 as fine.
    Hoping my reply could be helpful to you.
    Best Regards,
    Wang Li

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, June 24, 2015 4:43 AM