how big is your data set? i remember MySQL degrading when the tables got too big, i think around 100M rows or so. the data set probably didn't fit in memory either.
i don't know how much of a difference it makes, but we were also moving all the data across the wire (vs. what i'm guessing is local access on your machine), and probably about 50% writes.
i might be off on the 6K number... this was all some years ago, so it's a little fuzzy... but i don't think it was 'tens or hundreds of thousands' by any means.
i don't know how much of a difference it makes, but we were also moving all the data across the wire (vs. what i'm guessing is local access on your machine), and probably about 50% writes.
i might be off on the 6K number... this was all some years ago, so it's a little fuzzy... but i don't think it was 'tens or hundreds of thousands' by any means.