Actually looking at your old version again you use just one single tx

Repeated tx.success() don't have an effect

Sent from mobile device

Am 29.08.2014 um 10:57 schrieb "'Curtis Mosters' via Neo4j" 
<neo4j@googlegroups.com>:

> Tested in AWS on Intel Xeon CPU E5-2670 v2 @ 2,5 GHz.
> 
> With the addition I need for 1 mio lines ~100 sec
> 
> With my old version of inserting every line it was 14 sec.
> 
> So somehow batch commiting is much slower.
> 
> Am Donnerstag, 28. August 2014 22:18:46 UTC+2 schrieb Michael Hunger:
>> 
>> 
>> Am 28.08.2014 um 19:17 schrieb 'Curtis Mosters' via Neo4j 
>> <ne...@googlegroups.com>:
>> 
>>> Hi I don't like the current speed of Neo4j with Java API.
>>> 
>>> I have written an example that just inserts random data. In the case 160k:
>>> 
>> Change it to batching commits every 30k to 50k nodes not every node.
>> 
>> 
>> Transaction tx = graphDb.beginTx();
>> 
>>> for (int i = 0; i < 160000; i++) {
>>>                 myFirstNode = graphDb.createNode();
>>>                 myFirstNode.setProperty( "id", "1" );
>>>                 myFirstNode.setProperty( "name", "Duane Nickull, I 
>>> Braineater" );
>>                    if (i % 30000 == 0) {
>>>                     tx.success();
>>                        tx.close();
>>                        tx = graphDb.beginTx();
>>                   }     
>>>             }
>> 
>>>                     tx.success();
>>                        tx.close();
>> 
>> With the java API you usually can import 50 to 100k nodes per second.
>> 
>>    
>>> 
>>> this needs 22 seconds + ~2 minutes of tx.success() finishing or so. That's 
>>> pretty bad if you ask me.
>>> 
>>> So how can I improve the speed of the insert.
>>> 
>>> Already thought about it, maybe with:
>>> 
>>> disabling tx
>>> declare massive insert
>>> inserting every 10k
>>> So yeah basically help me to speed it up. Please don't say to use the 
>>> batch-inserter. He is fine but noch practicable for me.
>>> 
>>> Thank you.
>>> 
>>> 
>>> -- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to neo4j+un...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to