dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlCommand Class / FetchSize Property

In This Topic
    FetchSize Property (PgSqlCommand)
    In This Topic
    Gets or sets the number of rows that will be transferred across the network at a time if FetchAll is set to false.
    Syntax
    'Declaration
     
    Public Property FetchSize As Integer
    public int FetchSize {get; set;}

    Property Value

    The number of rows that will be transferred across the network at a time. The default value is 0.
    Remarks
    If 0 value is assigned, a value of this parameter will be determined automatically and it will be changed dynamically when executing read operations. If you do not want to have a specific number of rows be fetched at a time, it is better to keep this default value.
    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