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.
When to specify PacketSize
You must specify the PacketSize parameter before connecting
to the database.
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
SNC SQL Native Client for Microsoft SQL Server
PacketSize=value
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). |
PacketSize=512 (4096 for SNC)
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.
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:
2048
Application Type the following in code:
SQLCA.DBParm="PacketSize=2048"
