Hi Tim,

Many eons ago I had to remove table encryption from some tables with a lot of columns because the time to run relevant stored procedures was too long.  I'm guessing that's not really a problem anymore if the tables are being buffered?

= Steve

Steve,

<< Many eons ago I had to remove table encryption from some tables with a lot of columns because the time to run relevant stored procedures was too long.  I'm guessing that's not really a problem anymore if the tables are being buffered? >>

Actually, no, it would still be an issue because the encryption will still be run when a row/index page/BLOB block is "written" by the upper layers of the engine, and these layers are unaware that lower layers are buffering a lot of the data.

Tim Young
Elevate Software
www.elevatesoft.com