Frustrated with the speed of the SQL output directives, I just ran a little experiment.
I used -o:sql to dump a log query on a 10MB IIS file. It took 2:30 (I'm using the COM wrapper).
I then used the "interactive mode" in COM, assembled a System.Data.DataTable by hand, and then used System.Data.SqlClient.SqlBulkCopy to bulk insert to the database. It took 18ms.
I don't understand why LogParser's -o:sql output directive is over 8000x slower than my crappy code. Am I doing something wrong, or is this a known issue?
I'm using SQL Server 2008, if that makes any difference.