Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

hi folks, I am considering full encryption of one of my databases, and wanted to understand how to assess performance impact of full db vs (specific) table only encryption. Is there a recommended approach to assess performance degradation?

thanks much for any thoughts, Cosmin

asked 31 May '16, 09:41

cosmini's gravatar image

accept rate: 0%

I do not know whether that will help, but here's a snippet from the (older) whitepaper "Securing SQL Anywhere Server 10", page 27 - I would think the relative overhead should be similar for newer versions and hardware, but as usually YMMV:

Performance analysis

Performance is only slightly impacted when data is encrypted because SQL Anywhere is very efficient in encrypting/decrypting data. In lab tests, when databases are encrypted with AES or AES_FIPS, the performance decrease is between 2-3% on data retrievals and as much as 5% on data insertion. These results are based on the insertion/retrieval of 2.5 million rows to and from a single table on a Pentium 4 2.4 GHz system with 1024 MB RAM.

permanent link

answered 31 May '16, 16:02

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 31 May '16, 09:41

question was seen: 1,699 times

last updated: 31 May '16, 16:02