dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / InitialLobFetchSize Property

In This Topic
    InitialLobFetchSize Property
    In This Topic
    Gets or sets the number of bytes of LOB data to prefetch and cache when querying data containing LOB columns. Default value is 0, which means no data is prefetched.
    Syntax
    'Declaration
     
    Public Property InitialLobFetchSize As Integer
    public int InitialLobFetchSize {get; set;}

    Property Value

    The number of bytes of LOB data to prefetch and cache when querying data containing LOB columns.
    Remarks

    Setting this property allows improving performance of getting data when the data contains small LOB values.

    This property works only when the version of both Client and server is 11 or higher or in the Direct mode with the server 11 or higher.

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also