Large db

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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 ha scritto:

Quoted text here. Click to load it

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

Site Timeline