Hi, I have a script that parses some log files and feeds the data into a MSSQL database table, using DBI. The problem is that sometimes the log files is generated too fast for my script to keep up. I had success in reducing trips to the databases by putting multiple SQL INSERT statements in one statement handle. However I am now planning on moving the database to mysql, which does not support multiple SQL statement in one statement handle. The script is already running locally on the database server. Any suggestions?
Thanks Yimin -------------------------------------------------------------------------- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com
