The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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
91459
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
30.9k310457668
accept rate: 33%

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:

×33

question asked: 31 May '16, 09:41

question was seen: 312 times

last updated: 31 May '16, 16:02