ive got log parser on perl and it uses mysql insert or update command on every line. Like:
Log line 1: 2012-12-01 12:12 [perld] Hello world #1 .... Log line N: 2012-12-01 12:NN [perld] Hello world #N
it parses this lines and get "timestamp" and "#N" and inserts them into mysql db (parses line with perl::tail function).
Ive got about 100 lines/second so there would be about 100 inserts ti mysql.
Is there any solution/algorithm to optimize that? or maybe i should use something like buffer with insert?