January 28, 2009 at 4:15 am
Hi,
We are planning to go for a column level encryption for a huge table about 3 millions of records.
Would like to know what will be the performance impact on the query. This table is the master table and mainly used for retriving details.
What all the points I need to consider before implemening encryption.
Right now we have planning to select Certificate/Symmetric key mechanism.
Thanks for your time.
"More Green More Oxygen !! Plant a tree today"
January 31, 2009 at 8:53 am
No one can know the impact on the performance. It depends on to many factors that we don’t know. For example – The type of encryption that you’ll use, the algoritim that will be used, the hardware that you have, the amount of usage on the column that you’ll encrypt, Is there a search that is based on the encrypted column?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 9, 2009 at 7:26 pm
What is your planned use for the encrypted data?
How often is the encrypted data accessed/updated?
If you plan on searching on the column that is encrypted you will certainly experience a performance drop since all 3 million rows would need to be decrypted before it is considered for selection. Please see my blog entry on the topic of searching encrypted data.
As the previous poster noted, the algorithm that you use can also affect the performance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply