Large db

Hi,
i have some problem when trying make insert a lot of row in a large db.
I have to pharse a 10 file of 1 million of record and insert it into a
table ...
when arrive at around 1 million of record, every 1000 / 2000 records,
the query take 1 or 2 second to make 1 insert, then restart with a
normal fast inserting ...

in first i think was an hardware problem (like hd with bad sector or
similar) but i changed pc and the problem persist

the so is slackware 10.1 with recompiled mysql 5.1
the client program that made the insert is a vb application and the
odbc is 3.51

i think is a problem of mysqld but i can't identify it ...
i need urgent help

ty all in advice

Re: Large db

Tund3r@gmail.com ha scritto:

> Hi,
> i have some problem when trying make insert a lot of row in a large db.
> I have to pharse a 10 file of 1 million of record and insert it into a
> table ...
> when arrive at around 1 million of record, every 1000 / 2000 records,
> the query take 1 or 2 second to make 1 insert, then restart with a
> normal fast inserting ...
>
> in first i think was an hardware problem (like hd with bad sector or
> similar) but i changed pc and the problem persist
>
> the so is slackware 10.1 with recompiled mysql 5.1
> the client program that made the insert is a vb application and the
> odbc is 3.51
>
> i think is a problem of mysqld but i can't identify it ...
> i need urgent help
>
> ty all in advice

sorry, if i made 2 insert on different db at the same time ... the
inserts stops and restart at the same time!!!!