Decrypting large amount of Data

darkie88

Hi guys,

I need some advise and guide here. Currently I have around 4000 records in my database. Some of the column data are encrypted with blowfish algorithm (128-bit key length).

Now the problem is, every end of the month, I need to generate a report and one of the encrypted column is selected. Therefore, I would like to know, is there any proper method to decrypt all the records in that column ? ( besides decypt it 1 by 1 )

For your info : Encryption and Decryption is deal with a function. Usually, before it display a few record to the interface, it will do decryption first. ( using overriding )

Appreciate if anyone could guide and help me on this.

Thank you so much

alanzhao

Ok, you don't display 4000 records at once right? maybe 20 record at a time or a page. To keep it simple I would just decrypt record 1 by 1.

darkie88

alanzhao wrote:
Ok, you don't display 4000 records at once right? maybe 20 record at a time or a page. To keep it simple I would just decrypt record 1 by 1.

yeap, the reports usually need to generate more than 1000 records.
just because one of the selected column is encrypted and cannot be avoided, so i need some advise here.

idea like using array or generate to cvs and then only decrypt it or..... etc etc.