Foxhound is the better* Database Monitor for SQL Anywhere. *better: More thorough, more relevant, more effective. ...more Alerts, more All Clears, more details, more control in your hands.

Breck Carter
mail to: bcarter@bcarter.com

## Tip 77: Sybase SQL AnywherePerformance Tips & Techniques

### 6 - Use A Large Page Size

The DBINIT -p option can be used to set the page size to something other than the default of 1024 bytes. 4096 is highly recommended for large databases because it significantly reduces the number of index levels required. DBINFO can tell you what the current page size is but there is no way to change the page size after a database has been created.

When starting the server the -gp 4096 option gives you the freedom to start individual databases in any order regardless of their page sizes. This is important if you have no control over the order in which client applications start databases of differing page sizes.

Figure 6 shows the commands to create two databases with different page sizes and then launch the server and start the database with the smaller page size. At this point it is OK for a client application to start the other database because the -gp 4096 parameter was specified for the server.

Figure 6 - Specify Page Sizes With -p And -gp
 DBINIT -p 4096 c:\test\big.db DBINIT -p 2048 c:\test\small.db DBSRV50 -xNamedPipes -gp 4096 -nTesting c:\test\small.db -nSmall