Chapter 2 The Database Server
21
This is useful for using the Interactive SQL INPUT command to load large
quantities of data into a database.
The
-b option should not be used if you are using LOAD TABLE to bulk
load data.
When you use this option, the database server allows only one connection by
one application. It does not keep a rollback log or a transaction log, and the
multi-user locking mechanism is turned off.
When you first start the database server after loading data with the
-b
switch, you should use a new log file.
Bulk operation mode does not disable the firing of triggers.
–c command-line option
Set the initial memory reserved for caching database pages and other server
information.
[ dbsrv7 | dbeng7 ] -c [
integer
|
integer
K |
integer
M |
integer
P ] ...
All operating systems and servers.
The amount of memory available for use as a database server cache is one of
the key factors controlling performance. You can set the initial amount of
cache memory using the
-c command-line option
The more cache memory that can be given the server, the better will be its
performance.
The units K and M can be either lower case or upper case. If K or M is not
supplied, any integer less than 10000 is assumed to be in kilobytes, and any
integer 10000 or greater is assumed to be in bytes. For example,
-c 4096
means 4096KB or 4 194 304 bytes. Whereas,
-c 200 000
means (an
unreasonably small) cache of 200 000 bytes.
The unit P is a percentage of the physical system memory, and if you use
this, the argument is a percentage. You can use % as an alternative to P, but
as most non-UNIX operating systems use % as an environment variable
escape character, you must escape the % character. To use 50 percent of the
physical system memory, you would use the following:
dbeng7 -c 50%% ...
If no -c option is provided, the database server computes the initial cache
allocation as follows:
1 It uses the following operating-system-specific default cache sizes:
♦
Windows CE 600K
Description
Function
Syntax
Applies to
Description
To Next Page
Loading...