I m using this process as given in this link to encrypt my entire database here i have use 1 master key 2 certificate 2 symmetric key with algorithm aes_256 i build a raw table where i stored all the encrypted data from the main table which is been protected by 1 procedure and 2 trigger one for update and another for insertion then i created a view of the same name of the main table plz for more reference check the link
But when i alter the code in my database having data more then 200 tables and few tables containing 1400000 rows each and every query slow down so i need to do performance turning. for what i m looking into some alternative for big database i know that encrypting entire database will slow down but it is the requirement and delay can t be accepted above 10 sec but now i m having above 2 min suggest me what to do
Please check the code . and suggested me about any performance tuning that i can work on it i thought of changing in sql query changed in where clause as we will convert the sql where condition statement into encrypted form n check into the row table but thing is dat in certain cases the application want entire tables in hand that will again cause error