Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » Using UltraLite Databases » UltraLite performance and optimization


UltraLite optimization strategies

Different UltraLite deployments of UltraLite may require very specific settings to tune the database for your needs.

Early versions of Palm OS

Early versions (for example, version 4.x) of Palm devices only have approximately 200 KB of RAM. This limitation can cause problems due to the dynamic memory requirements of UltraLite 11.

Platform strategies   There are two alternatives:

  • Upgrade to Palm OS 5.x. This suggestion is the preferred option.

  • Downgrade UltraLite to version 9.0.x.

Database optimization strategies   You should ensure that you are doing the following:

  • For the CACHE_SIZE creation parameter   Do not establish a connection using this parameter, and allow UltraLite to set the default value. If you set your own value, you may inadvertently cause problems with the dynamic memory required for synchronization.

  • For the page_size creation database property   Create a new database with the smallest possible page size for your application. While 1 KB is the smallest page size, a 2 KB page size is the size typically used for Palm OS.