I did some tests earlier where I inserted 100,000 rows into a
table (table definition below). First, I did it without using
transactions and it took 243 seconds approximately. Then, I
did the same test using transactions, and it took 28 seconds.
I am using MySQL v4. Here is the table definition:
CREATE TABLE users (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
num1 FLOAT(9,2) NOT NULL DEFAULT 0.0,
num2 FLOAT(9,2) NOT NULL DEFAULT 0.0,
I guess my question is, how can this be? I was lead to believe that
using transactions would slow things down but the opposite appears
to be happening. Can anyone offer an explanation as to why it took
so much longer to do the inserts when not using transactions ?