Insert multiple values within a transaction with LAST_INSERT_ID

[Matthias Bendewald]

Hi Folks,
i have a little performance issue. I use a innodb database and C# to connect to it.
I want to insert values into two related tables.
Table one has an ID field which is pointed to in table two.

So i do the following within a transaction for multiple datasets:

INSERT INTO table1 (...) VALUES (...);
and then
INSERT INTO table2 (table1_id, ...) VALUES (LAST_INSERT_ID(), ...);

Works fine. But it is really slow (about 80 inserted Values per second).
What can i do to speed it up?

MySQL server is 5.1.41, i am connecting to it via C#.net Connector which is pretty fast in almost all other situations.