Configuration Settings

This section discusses the configuration settings that have changed in Pervasive PSQL v10.

Cache Allocation Size

The value required and returned for the cache allocation size varies depending on the combination of Pervasive PSQL server and clients, as show in the following table.

Table 1-5 Cache Allocation Size Value By Product Version
PSQL Server		PSQL Client		Value Required and Returned		Example: 1 Gigabyte (GB) Cache
v10	Prior to v10	v10	Prior to v10	Bytes	Megabytes (MB)
						1,024
						1,073,741,824
						1,073,741,824
						1,073,741,824

When you configure the setting, you enter a value either in bytes or megabytes depending on the combination of server and client as shown above. The Pervasive PSQL utilities inform you of the units required and returned. For example, if you use a Pervasive PSQL v10 server with v10 clients, the Pervasive PSQL Control Center displays the setting as "Cache Allocation Size in megabytes." For any other combination of server and clients, the Pervasive PSQL Control Center displays the setting as "Cache Allocation Size in bytes."

Also note that the limit for cache allocation size in 64-bit Pervasive PSQL is 4 terabytes. The limit is 4 gigabytes in 32-bit Pervasive PSQL.

Using Distributed Tuning Interface (DTI), cache allocation size is configured the same as any other setting. In Distributed Tuning Interface Guide, see Obtaining a Setting ID Using DTI and PvSetSelectionValue() .

Supported Protocols

The engine configuration setting "Supported Protocols" now defaults to TCP/IP. (The client setting still defaults to all three supported protocols.) See Supported Protocols in Advanced Operations Guide.