Sun Feb 10 16:46:25 MST 2013 - Made modifications to database schema to accomidate large record sets (1k+). Set default options for temporary table creation. Testing: Linux lamp.dev 2.6.32-279.11.1.el6.x86_64 #1 SMP, 2048MB - 208100 Records decrypted, new key generated & re-encrypted in 46.2 minutes. TODO: Add in an optional backup prior to key rotation procedure to ensure data integrity in a catastrophic event.
Sun Feb 10 16:46:42 MST 2013 - Made modifications to database schema to accomidate large record sets (1k+). Set default options for temporary table creation. Testing: Linux lamp.dev 2.6.32-279.11.1.el6.x86_64 #1 SMP, 2048MB - 208100 Records decrypted, new key generated & re-encrypted in 46.2 minutes. TODO: Add in an optional backup prior to key rotation procedure to ensure data integrity in a catastrophic event.