http://qs321.pair.com?node_id=78751


in reply to Mysql, CSV, and flatfiles, a benchmark.

I agree with TheoPeterson's points, and I will add on to warn that there are more important things than speed:

...and so on. I know that you weren't using your benchmarks to start a war about MySQL vs flat files, but you did mention that you were looking for the "best way". In my humble opinion, the fastest way isn't the best way in this case. For a lot of projects, messing with flat files or CSVs are just too much of a headache.

It is good to see the benchmarks though. Thanks for taking the initiative!