spring - What is the best way to do BULK INSERT using Java? -

-

i'm trying make app can save lot of structured objects in database. using spring data jpa (with hibernate + mysql (myisam tables + foreign keys)) write code data services easy , pleasant using spring data repositories performance slow.

for example, tried insert 100 records in 1 table , takes 8,5 sec.

i've try same insert operations straight in mysql cmd (using hardcoded "insert strings" in procedure) , shows me time - 0,85 sec. such result me slow, problem of mysql

reading forum have found post says spring data jpa can't bulk insert properly.

how can make app more faster? want use bulk insert operations size 1000 or more.

the situation complicated fact can't store object db in 1 bulk (despite size of bulk)

to make clearer:

the objectgame contains list of objectround objectgame contains list of objectgameplayer objectround contains list of objectroundcard objectgameplayer contains list of objectplayercard objectgameplayer contains list of objectplayerbet

of course, insert objectgame needs make several steps: insert bulk of objectgame , ids having objectgame's ids insert bulk of objectround , ids ... , on

which way more appropriate me?

using spring data jpa, jdbc, hibernate, mybatis? or way ?


Comments

Post a Comment

Popular posts from this blog

html5 - What is breaking my page when printing? -

-
Image
i have questioner , don't know why when printing it's creating break before first question. live demo (link) i able resolve issue removing fieldset container had wrapped in.. having fieldset element causing of fields grouped together, , since not fit on first page, being pushed second page. removing fieldset element, able firefox print first 2 questions on page 1 identically chrome. it seems not new problem firefox , fieldset not playing nice found old bugzilla ticket 2008 has persisted , still being commented on in 2014 (link) if retaining fieldset important, found solution else came here (link) <script type='text/javascript'> $(window).bind('beforeprint', function(){ $('fieldset').each( function(item) { $(this).replacewith($('<div class="fieldset">' + this.innerhtml + '</div>')); } ) }); $(window).bind(
Read more

c# - must be a non-abstract type with a public parameterless constructor in redis -

-
when save object, got below error must non-abstract type public parameterless constructor in order use parameter 't' in generic type or method 'servicestack.redis.redisclient.store<t>(t) redisclass.getinstnace().store(msg); // error here redisclass.getinstnace().save(); as third party's class, can not edit how save object? could create wrapper around third party object call constructor, store wrapper? e.g. public class mywrapper { public thirdpartyobject thirdpartyinstance { get; set; } public mywrapper() { thirdpartyinstance = new thirdpartyobject("constructors"); } }
Read more

ajax - PHP/JSON Login script (Twitter style) not setting sessions -

-
i'm having trouble getting twitter style login work properly, reason gets stuck at session_register("useremail"); session_register("userpass"); and doesn't redirect after it. if enter wrong account data, works , appropriate error message pops up. this full code: <?php if(empty($_post['email']) || empty($_post['password'])) { die(msg(0,"all fields required")); } if(!(preg_match("/^[\.a-z0-9_\-\+]+[@][a-z0-9_\-]+([.][a-z0-9_\-]+)+[a-z]{1,4}$/", $_post['email']))) die(msg(0,"you haven't provided valid e-mail")); $host="localhost"; $username="root"; $password="x"; $db_name="x"; $tbl_name="x"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select db"); $useremail=$_post['email']; $userpass=
Read more