I need to load data from sql to mongo. in sql i have 42 tables , so a
document needs to be generated by those 42 tables, just i created a stored
procedure which will deal all the tables and with the help of C# class
structures i loaded those records as a batch of 5000, which is taking 7.5
hours to load complete 2 million records.
is there any better way to load the data to mongo?
i tried in another way like
1. loaded base table
2. updated with the second table using Save method which take 3.5 hours to
update 2 million documents.( i need to do all other 41 tables and this is
time taking process)
please help me in this regard.