how to reduce the DB operation

[Baby Lion]

while ( get a record from net)
INSERT INTO THE DB



is there any way to reduce the DB operation
it appears to have too much disk operation
the sound from the disk make me afraid


I was thinking about to write the records into a file ,and the transfer
to the db server , and make all of them updated . is it a better way?

 

[Davide Consonni]

I was thinking about to write the records into a file ,and the transfer
to the db server , and make all of them updated . is it a better way?

mysql has bulk insert:

INSERT INTO x (a,b)
VALUES
('1', 'one'),
('2', 'two'),
('3', 'three')

orrible but work

 

[Chris Brat]

If your inserts are all into the same table then you can create a
prepared statement and add the values to it using the addBatch() method
then execute the batch with the executeBatch() method.

This should decrease the overhead to some degree.

 

[Baby Lion]

Great!
Thank You.
Chris Brat 写é“：