MySQL Forums
Forum List  »  Optimizer & Parser

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Insert multiple values within a transaction with LAST_INSERT_ID
2594
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.