The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

cosmini
76138
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
29.3k287438644
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×32

question asked: 31 May '16, 09:41

question was seen: 204 times

last updated: 31 May '16, 16:02