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:
>
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 transact
