Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WindChaser
Posting Yak Master
225 Posts |
 Posted - 2014-07-16 : 12:03:29
|
| Hi folks,On SQLServer 2008, I started encrypting data using EncryptByPassphrase/DecryptByPassphrase and I use a 45-character string as the passphrase. Some clients have reported a drag on performance w.r.t. to prior software versions when encryption was not used at all. So I did a few tests to see if I might not reduce cypher strength to gain performance. However, using a shorter passphrase of 10 characters, there doesn't seem to be any significant difference in performance when encrypting/decrypting a field for 10000 records. Given that a 45-character cypher strength is obviously greater than that of a 10-character cypher, I would have expected a cost in performance with a stronger cypher. Can anyone provide any reasoning to explain these results?Thanks! |
|
|
|
|
|
Performance impact of encryption