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.
You can benchmark test different cache sizes and watch for performance to change abruptly. Your cache should be large enough to have a good working set of pages. Consider the following ideas to help you stress the cache:
If you find that increasing the cache does not improve the performance of an encrypted database, consider obfuscating the data rather than encrypting it. Obfuscation can yield better performance while still offering some security benefits; the obfuscation algorithm uses less code compared to strong encryption, and performs fewer computations. Simple encryption performance should only be marginally slower than no encryption at all. However, your security requirements must ultimately dictate whether you choose to use strong encryption or not.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|