I have a MySQL database where all the data contained is encrypted (2200 records, 30 columns) to protect student's personal data. When running reports, I create a duplicate blank table, query the encrypted table, decrypt each record and add to the new temporary table. I then can run my query on the decrypted data and drop the temporary table when I'm done. This takes too much time and overhead.
What I'd like to do is create a cached version of the decrypted table in memory, which would be available to any function, any user, within the site - and then run queries off of the memory-based table. I realize I'd have to either destroy and recreate the table, or update the cached data if any table data changed, but that's ok.
I'm leaning toward using WinCache, as the site is hosted on a Windows server.
