PacketSize (ASE, DIR, SNC, SYC) – PB Docs 126

PacketSize (ASE, DIR, SNC, SYC) database parameter

Description

When connecting to a database, specifies the packet size in
bytes that you want the server to set for transferring data to and
from your PowerBuilder application. A packet is
a fixed-size chunk of data for sending information over a network.

If the server has space limitations, it sets the packet size
to less than the specified PacketSize value. Otherwise, it sets
the size equal to the PacketSize value. The default value is 512
bytes.

note.png When to specify PacketSize

You must specify the PacketSize parameter before connecting
to the database.

Controls

  • ASE, SYC SAP Adaptive
    Server Enterprise

  • DIR Sybase DirectConnect

  • SNC SQL Native Client for Microsoft SQL Server

Syntax

Parameter

Description

value

A value specifying the packet size in
bytes that a database server sets for transferring data to and from
your application. The value must be a multiple of 512 bytes (default=512
bytes).

Default

PacketSize=512 (4096 for SNC)

Usage

When to set

If your PowerBuilder application sends or receives large amounts
of text or image data from the server, setting the PacketSize value larger
than the default 512 bytes might speed performance by causing fewer network
read and write operations.

Adaptive Server Enterprise and DirectConnect

Before setting PacketSize for use with an Adaptive Server
Enterprise or DirectConnect database, you or your system administrator
must set the following configuration variables on the server for
PacketSize to take effect:

  • Additional netmem

    Sets the maximum size of additional memory that can be used
    for network packets larger than the default size.

  • Maximum network packet size

    Sets the maximum network packet size for all database users.

For instructions on setting these configuration
variables, see your database documentation.

Examples

To specify that the database server should set the
packet size equal to or less than 2048 bytes:

  • Database profile

    Type the following in the Packet Size box on the Network page
    in the Database Profile Setup dialog box:

  • Application

    Type the following in code:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x