I'm writing an application that requires me to encrypt all data within SQL
Server. On each page in my application I will need to load somewhere between
200 and 1000 records and decrypt the two fields returned for each record.
This is gobbling up major overhead..! Should I dump the decrypted data into
a temp table that deletes after the users session ends? Or possibly put the
entire collection into a session as an array?

Thanks