Different UltraLite deployments of UltraLite may require very specific settings to tune the database for your needs.
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.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |