Hi Tim,

Back in the Dark Ages before ye holy buffering was introduced in 2.28 using a stored procedure to iterate through rows of an encrypted table with a lot of columns and rows could be really slow.  Removing the encryption sped things up.

Is there a performance improvement when using buffering with encrypted tables in the above scenario?

= Steve

Steve,

<< Is there a performance improvement when using buffering with encrypted tables in the above scenario?  >>

Unfortunately, no - the encryption works at the row/page/block level, so isn't affected by the file I/O buffering and behaves exactly the same.

This is another area where the single-file format will be better because it can perform encryption at the lower database block level, thus optimizing how often the decryption/encryption needs to occur on reads/writes.

Tim Young
Elevate Software
www.elevatesoft.com

<<  This is another area where the single-file format will be better because it can perform encryption at the lower database block level, thus optimizing how often the decryption/encryption needs to occur on reads/writes. >>

Thanks Tim.

= Steve