PacketSize (ASE, 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.
When to specify PacketSize
You must specify the PacketSize parameter before connecting to
the database.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
SNC SQL Native Client for Microsoft SQL Server
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
|
1 |
PacketSize=value |
|
Parameter |
Description |
|---|---|
|
value |
A value specifying the packet size in bytes that a |
Default value
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
Before setting PacketSize for use with an Adaptive Server
Enterprise 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:12048 -
Application
Type the following in code:
1SQLCA.DBParm="PacketSize=2048"