SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
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  

Aged Yak Warrior

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.
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

Patron Saint of Lost Yaks

30407 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

Norsk Yak Master

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.05 seconds. Powered By: Snitz Forums 2000