Hi All,
If we go with the Appian Cloud Database Encryption,(https://docs.appian.com/suite/help/23.2/Appian_Cloud_Database_Encryption.html#default-encryption-for-tables)
1. What is the performance impact - the article mentions small performance impact. Has anyone done this and what was the impact on performance(specific in milliseconds,seconds)?
2. We have views defined in application which are used to display some dashboards on UI - will these be impacted as well?
3. As per article,the phpMyAdmin will continue to show data as before encryption so how do we verify that encryption is working correctly
Discussion posts and replies are publicly visible
As this is "only" an encryption of the data when stored to disk aka "at rest", there is no other impact.
1. It's not quantified but they do advise to use encryption on certain tables (not all tables) so I would think it would be significant enough.
A small performance impact on the database is expected when encryption is enabled. This is due to the processing that goes into encrypting and decrypting your data at runtime. Thus, it is advisable to use the database encryption feature only when strictly required for compliance reasons.
2. Views would be affected if the underlying table has encryption.
3. You can't but you can probably check for it in the structure of the table since you specify it in the CREATE statement.
CREATE TABLE t1 ( id int PRIMARY KEY, name varchar(255) ) ENCRYPTED=YES
What about the performance impact on queried from tables and views?