(Dreyer, Jason Jason.Dreyer@deg.state.wi.us):
The differences between MySQL versions and table types may not be the determining factor in performance here.
Absolutely; lies, damned lies, and benchmarks, and all that. Disk I/O may well be a major culprit. Memory/CPU usage probably isn't. I'll run some more tests to check some of those things. I'll also run some tests for things like having the database on a separate machine, even PostgreSQL if I have the time (I'd appreciate it if the fellow who said he had it working would send me a patch).
But I did want to get this initial set of numbers out there for discussion, and even these first limited results do give me some warm fuzzies about MySQL 4.0.12, which was something I wanted to look hard at because I wanted some of its features.
I'd lso appreciate suggestions for other benchmarks (specific MySQL settings, for example).