We do same amount of data-load every week on 2 different env.
1st env: TEST box : 3.6 version (compatibility version is at 3.4 version)
2nd env : TEST1 box : 4.0 version (compatibility version is at 3.6 version)
every week we need to drop the collection and reload the collection from oracle to mongodb.In 3.6 it takes 3 hrs and 4.0 it is taking 5 hours.Is there any performance issues?
As we are using same hardware configuration and there is no change in data. So would like to know why it is taking too much time.
collection name count size of the collection
emp1 69 million 13 GB
emp2 20 million 7gb
Can this performance be improved?
During slowness issues --> what all check-points we need to check to improvise our db performance?