Performance of encrypted db?

[Ivan Smahin]

Hello Tiemo,

Tuesday, October 7, 2008, 3:28:26 PM, you wrote:

> Second: Is there any relevant difference in performance (in reading the
> encrypted db records), if I encrypt the structure or the records?

Encrypting the structure only you get almost zero penalty and it is
only on db opening stage (Any DDL operation goes to the schema via
encryptor of course - so here is also some overhead).

Sure, there is some overhead with encrypt/decrypt if you encrypt the
data. "Relevant difference" depends on situation. Say - if the data
relations is most secure thing (not the data self) I would not use
data encryption - because of it is hard to get such relations just
reading the db files.

On the other hand you can encrypt particular tables only - not a
whole database!


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com