Easy Data Transform has created hundreds of reports for me at work. On my personal Mac, I mostly use EDT for simple things on small data sets. About once a year I get cranky about property taxes and give EDT a good workout.
This morning, happily firing salvos at tax rolls, I got a popup saying I had processed more than 10,000,000 lines of data.
I think I’m getting my money’s worth. Don’t tell Andy, but that works out to EDT costing less than a tenth of a thousandth of a cent per record. So far. I’m still at it.
The bulk of that processing is on tax rolls, the major element of which has 409 fields per record. That means I’ve processed a data field for about every four inches from here to the Moon.
The quirk or two I found were always quickly addressed. I can’t remember an outright crash other than running out of memory this morning. EDT terminated, I set its memory limitation in EDT preferences to 8 gig, and life went on, four inches at a time, from here to the moon.
EDT is great. Once I finish this current round of data mining I’ll post sample transforms which are run against property tax data in Tyler Technologies transfer tape format.
Currently I control and report a large test project with the EDT evaluations and check and increase the counter by 7.5 mio per working day. A long way to reach the billion