Search code examples
bigdatamonetdbgenerated

generate 100 milions record with monetdb


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 .


Solution

  • I would suggest importing by either switching off autocommit (START TRANSACTION; ... COMMIT; or using the COPY INTO method.