encryption impact

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

encryption

asked 31 May '16, 09:41

cosmini
91●4●5●9
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Barth
40.2k●361●550●822
accept rate: 34%

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

encryption ×46

question asked: 31 May '16, 09:41

question was seen: 1,686 times

last updated: 31 May '16, 16:02

SAP SQL Anywhere

encryption impact

Follow this question

Related questions