Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Buffering and Table Encryption. |
Thu, May 17 2018 8:34 PM | Permanent Link |
Steve Gill | 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 |
Fri, May 18 2018 3:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, May 18 2018 6:10 PM | Permanent Link |
Steve Gill | << 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |