MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Insert multiple values within a transaction with LAST_INSERT_ID
Posted by: Matthias Bendewald
Date: April 19, 2011 01:18AM

Hi Rick,
thank you for the tip on BBCode. I found my mistake - well, it wasn't the database nor the missing transaction, it was an exception thrown within my long loop. I was far too stiffened on the performance while there was that terrible error in my code. Sorry for any circumstances you had with me and thank you for all that help.
After simply avoiding the exception the db was able to insert 800+ values per second, which is more than enough for me.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Insert multiple values within a transaction with LAST_INSERT_ID
6565
Matthias Bendewald
April 15, 2011 02:14AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID
3042
Rick James
April 16, 2011 08:12AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID
2182
Matthias Bendewald
April 18, 2011 04:46AM
Re: Insert multiple values within a transaction with LAST_INSERT_ID
1731
Rick James
April 18, 2011 07:34PM
Re: Insert multiple values within a transaction with LAST_INSERT_ID
2595
Matthias Bendewald
April 19, 2011 01:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.