Faster CSV Export?

David C shared this question 4 years ago
Answered

Hi. I have read others having this same issue but have not found a solution.


I am exporting over 1MM rows of data. This is taking hours to complete.

MongoDB has a batch export feature.

Can we utilize this with NoSQLBooster?

Thanks

Replies (3)

photo
1

Please give mongoexport utility a try.

/417300a494e69f56cc6b310e53f080f4

photo
1

Thank you.


Yes I tried that. However it is only exporting about 1000 rows per second.

On our server, we are able to export at about 40,000 rows per second. But I require something that I can perform custom queries with.

photo
1

This second export option directly uses the mongoexport binary tool, and there is no faster way at present. You can use "copy command to clipboard" to clipboard and run the command line on in your server.

/3f6c7db4a70193ca969518c1db11766f

Leave a Comment
 
Attach a file