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:
Database optimization strategies You should ensure that you are doing the following:
For the CACHE_SIZE 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 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.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |