Hello ALL
I'm making a program that will read a file that haves more or less 500.000 lines.
The program filter this lines and record the data in a MySQL database. It will
record more or less 500.000 records.
I am reading the data of an archive text, sequentially, more or less
like this:
while (fgets(linha, 255, arq) != NULL)
{ / / I break the string in the correct fields
strsep( .....
/ / I record in the table... (insert into tablex values(....))
}
If my program only reads and process the data and dont try to insert it to the db,
the program runs ok.
But if I make it insert the data to the database, the mysqld process stills growing up
until the machine crashes.
I tried too, to use the " insert delayed " but it doesn't solved.
Then I change my program to write each 1000 records to a text file and execute the
LOAD DATA FROM FILE, but mysqld
stills crashing the machine.
In all the tests, the number of inserted records was around 97000.
Does anyone has some ideia of what I am making wrong? Or some ideia of
other modes to insert?
Sorry my bad English...
Thanks very much,
Wilson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
