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
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.
Query speed problem after encryption
Posted - 01/30/2009 : 07:05:46
