Sybase Adaptive Server Anywhere - Page 81

Chapter 3 Connection and Communication Parameters
63
Improvements occur particularly under the following conditions:
♦ The application fetches many rows (several hundred or more) with very
few absolute fetches.
♦ The application fetches rows at a high rate, and the client and server are
on the same machine or connected by a fast network.
♦ Client/server communication is over a slow network, such as a dial-up
link or wide area network.
The number of rows prefetched is limited both by the PrefetchRows
connection parameter and the PrefetchBuffer parameter, which limits the
memory available for storing prefetched rows.
$ For more information, see "PrefetchBuffer connection parameter" on
page 62.
♦ The following connection string fragment sets the number of prefetched
rows to 100:
…prefetchrows=100;…
ServerName connection parameter [ENG]
Synonym for "EngineName connection parameter" on page 57.
$ For more information, see "EngineName connection parameter" on
page 57.
StartLine connection parameter [START]
To start a database server running from an application.
Embedded databases
No StartLine parameter
You should supply a StartLine parameter only if you are connecting to a
database server that is not currently running. The StartLine parameter is a
command line to start a personal database server.
$ For a detailed description of available command line switches, see "The
database server" on page 14.
♦ The following data source fragment starts a personal database server
with a cache of 8 Mb.
StartLine=dbeng7 -c 8M asademo.db
Example
Function
Usage
Default
Description
Examples