Reputation: 1053
I have an Oracle DB of roughly 20 million record. I used the BatchInserter to insert the data in my model. The problem is that I have to loop over a result set containing the whole 20 million data to get the needed properties to insert. But it take too long time to do just the loop process.
Anyone tried something like that? and What is the best way to do it in an optimum time?
Upvotes: 1
Views: 331
Reputation: 41706
Can you share more details? Where do you have to loop?
Check http://neo4j.org/develop/import for some options.
If you have JDBC you can also drive the import directly from your JDBC results.
Just loop twice over the results, once for nodes and once for rels.
Upvotes: 1