peter.hamilton-scott wrote:
> 1. Is what I got fairly typical, within the curve,
> for InnoDB?
No way to answer this question without benchmarking on your platform, viewing the exact code, setting up a test environment and running benchmarks against same code, etc... So many different variables, it's impossible to make a guess.
> 2. Would it have been any faster using MyIsam?
Probably, since there is no need for the transactional container. But again, you'd have to test it. come to think of it, it would be good to test it without using a stored procedure as well. Currently, stored procedures produce a small performance penalty because of some overhead.
> 3. Is there a kind of unofficial world record for
> inserting records per second?
The TPC (Transaction Processing Performance Council) benchmarks are generally considered to be the gold standard for the who's who in the database world. But remember, the machines used to generate these benchamrks are *highly* tuned and *very* expensive in general. (http:tpc.org) The measurements are always in tpm/c which are complete business transactions per *minute*. The current record holder is 3,210,540 transactions per minute (IBM DB2 on eServer platform)
so, sad to say, your results are slightly below the world record :) But, hey, don't give up :)
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com