performance issue
Posted by: poseidon G
Date: February 05, 2007 10:47AM

i would like to improve my software performance. But I got weird result.
I examined 3 optional ways to insert rows into my MySql DB
1. Using Sql query (written in my java code)
2. Using store procedure.
3. Using bulk insert.
The result was unexpected, I tried inserting 50,000 new rows and the results are:
1. bulk insert 119000 ms.
2. Sql query 120703 ms
3. store procedure 169000

it’s seems not real I was expected that bulk insert would be much faster than store procedure which was should be much faster than regular Sql query.

I’m working with Windows XP
MySql 5.0.19
mysql-connector-java-3.1.12
doe's ant one knows how i got those realuts ?

Options: ReplyQuote


Subject
Written By
Posted
performance issue
February 05, 2007 10:47AM
February 05, 2007 11:02AM


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.