my assignment is make a database with 100 millions record in mongetdb.for now my solution is generate a big file db.sql then import . size of that file is bigger than 6gb. I have imported near to 2 days.and i don't know when it finish. Somebody help me ,please! thanks you .
I would suggest importing by either switching off autocommit (START TRANSACTION; ... COMMIT;
or using the COPY INTO
method.