Database Extraction
Posted in General
Forenoon watch, 8 bells (12:25 pm)

Today I had the problem of extracting encrypted user information from our online registration database in a bulk manner. I wrote a C++ program that connected to MySQL locally and queried for all the relevant records. I then had to load each one into a special class, decrypt it, dump it out in a tab-delimited format, and move to the next one. It took a little over 13 minutes to run. It extracted 19.242 records, way more than I expected to see. I figure that's about 24 records per second. It ate up around 94% CPU time, but only a small sliver of memory (I'm that good). :)

Someone's gonna have an unhappy day tomorrow when they have to import them, but not me. Hehe.

Leave a Comment »