Steve Ruby wrote:
Steve Ruby wrote:
I'm inserting 49,990 rows via file containing individual inserts
(1 insert per sql statement). The table contains 7 columns and 6
indexes.
Why is there so much difference on the time taken to insert the
files?
averages:
MyISAM45
Steve,
you should set autocommit=0 and only call commit after the
whole batch of inserts.
so then if I'm inserting via a mysqldump file I should
append commit; to the last line of the file?
yes, put on the first line of the dump file
set autocommit = 0;
and on the last line
Heikki Tuuri wrote:
Steve,
you should set autocommit=0 and only call commit after the
whole batch of inserts.
so then if I'm inserting via a mysqldump file I should
append commit; to the last line of the file?
If you use autocommit=1 and insert each row in a separate transaction,
I've been doing some testing to determine tradeoffs with performance
for using the Innobase or BDB tables.
The testing application contains bulk inserts which must be processed
as quickly as possible. The results I'm getting look very bad for
innobase. Am I doing something wrong?
I'm