SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Query speed problem after encryption
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lionofdezert
Aged Yak Warrior

Pakistan
885 Posts

Posted - 01/30/2009 :  07:05:46  Show Profile  Visit lionofdezert's Homepage  Send lionofdezert a Yahoo! Message  Reply with Quote
I applied encryption (Encryption By Key)to secur my data, in almost all of my table, but on selected columns in each table.
BUT
my simple select query even become 700% slow.

defenitly when i select records i need to decrypt all the encrypted data.

How can i improve my query performance.

* All the indexes are carefully applied and statisics are updated

SwePeso
Patron Saint of Lost Yaks

Sweden
30281 Posts

Posted - 01/30/2009 :  07:24:25  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You can't use indexes when searching on encrypted columns.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/30/2009 :  07:34:24  Show Profile  Reply with Quote
Encrypting data in a database is not such a good idea for exactly this reason. The only stuff I encrypt in the databases I work with are credit card numbers and passwords.

- Lumbago
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000