Sybase Adaptive Server Anywhere - Page 80

Connection parameters
62
♦ The following connection string fragment supplies the user ID
DBA and
password
SQL.
uid=DBA;pwd=SQL
Alternatively, you can set these parameters in the User ID and Password
text boxes in the connection window.
PrefetchBuffer connection parameter [PBUF]
Set the maximum amount of memory for buffering rows, in kilobytes.
Anywhere
32
The PrefetchBuffer connection parameter controls the memory allocated on
the client to store prefetched rows. In some circumstances, increasing the
number of rows prefetched from the database server by the client can
improve query performance. You can increase the number of rows
prefetched using the PrefetchRows and PrefetchBuffer connection
parameters.
$ For more information, see "PrefetchRows connection parameter" on
page 62.
♦ The following connection string fragment could be used to determine if
the PrefetchBuffer memory limit is reducing the number of rows
prefetched.
…prefetchrows=100;debug=yes;logfile=c:\ client.txt
The following string could be used to increase the memory limit to
256K:
…prefetchrows=100;prefetchbuffer=256
PrefetchRows connection parameter [PROWS]
Set the maximum number of rows to prefetch when querying the database.
Anywhere
10
Increasing the number of rows prefetched from the database server by the
client can improve performance on cursors that do only fetch relative 0 or 1,
with either single row or wide fetches. Wide fetches include embedded SQL
array fetches and ODBC block fetches.
Examples
Function
Usage
Default
Description
Example
Function
Usage
Default
Description