I am trying to load data from MongoDB To Neo4j, but job is running extremely slow. It is just inserting 30K records in ~3 hrs, when trying to load only 1 column. I'm using tMongoDbinput and tNeo4jOutput component for it.
We have requirement to load 50 Millions records to Neo4j.
Can anyone please help ?
You need to work out where your bottleneck is. Try this.....
1) Run your extract query in another querying tool. How quickly does it return all data?
2) Remove the insert functionality and remove any data processing functionality (or deactivate it), then run the data query part of the job. What rate do you get?
3) Switch the data processing functionality on, but NOT the insert part. Run it. What rate do you get?
4) Compare the two rates above with the rate you have given us here. That should indicate where your bottleneck is.
Once you have your bottleneck, give us as much info about that section as possible (screenshots, configs, etc).
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.