the code part which executes the SQL commands does not need to run after each line from the logfile is processed.
instead it is sufficient to run SQL statements once after logfile is analyzed and relevant data was read into $idqueue array.
so I moved this part into a separate function.
this is a quite simple but very performance-effective change.
the code part which executes the SQL commands does not need to run after each line from the logfile is processed. instead it is sufficient to run SQL statements once after logfile is analyzed and relevant data was read into $idqueue array. so I moved this part into a separate function. this is a quite simple but very performance-effective change.