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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » Using UltraLite databases » UltraLite performance and optimization


How database encryption and obfuscation affect performance

You can encrypt the database to increase the security of the information stored in UltraLite. However, you should note that there is an increase in overhead of between 5-10% as a result, resulting in decreased performance. The exact effect on performance depends on the size of your cache. If your cache is too small, encryption can add significant overhead. However, if your cache is sufficiently large, you may not see any difference at all. To determine what the optimal cache size for your scenario is, you can graph the database performance with benchmark tests.

 Stressing the cache
 See also