Configuration Issues

End users may need to know the following information about your Btrieve application. Include this information in the documentation you provide with your Btrieve application.

The amount of memory your application requires.

Your application may require more memory or disk space than Btrieve requires on its own. Establish the disk space and memory requirements of your application and communicate this information to your users. For information about Btrieve system requirements, refer to Getting Started With Pervasive.SQL.

Whether the application requires MicroKernel configuration settings other than the defaults. In particular, consider whether end users need to change these MicroKernel options:

Create File Version. Does your application need backward compatibility with a previous version of the MicroKernel? If so, instruct your end users to set an appropriate value for this option.

Handles. Does your application need to use more than 60 logical file handles at one time? If so, instruct your end users to set this option to an appropriate value.

Index Balancing. Does your application set the Index Balancing file attribute on every file it creates? If so, your end users can use the default of Index Balancing turned off. If not, you may need to instruct your end users to turn Index Balancing on at the MicroKernel level. For more information, see Index Balancing .

Largest Compressed Record Size. Does your application use compressed files? If so, use the guidelines in the Pervasive.SQL User's Guide to determine an appropriate value for this option. If not, your end users can set this option to 0.

Open Files. Does your application require more than 20 unique files to be open at the same time? If so, instruct your end users to set this option to an appropriate value.

System Data. Do all files in your database have unique keys? If so, the files are transaction durable. If not, your end users may want to set System Data to If Needed or Always in order to make the files transaction durable.

FPNW Support on NT. Are you using a path that is mapped to an FPNW volume on Windows NT? If so, make sure the MicroKernel Router's Requester setting is set to Yes. For more information, refer to the MicroKernel Router Options of the Setup utility, as described in the Pervasive.SQL User's Guide.

For descriptions of each of these configuration options, refer to the Pervasive.SQL User's Guide.