• Topic
  • Discussion
  • UdaWikiWeb.GlossaryEntryJDBDCFETCHBUFFERSIZE(Last) -- Owiki? , 2016-08-19 15:00:06 Edit owiki 2016-08-19 15:00:06


    /FBS or /FetchBufferSize is a Type 3 JDBC connect string parameter. The value passed by /FBS represents the number of rows of resultset data, which you want fetched before data is returned to your client.

    A high /FBS value reduces the need to traverse back and forth across the network. However, a high /FBS will result in longer intervals between the arrival of data. A smaller /FBS value entails a greater number of trips across the network. However, smaller /FBS values alleviate the potential for timeouts, when resultsets are large.

    See Also: JDBC, Type 3

    Referenced by...