Faster CSV Export?

David C shared this question 38 days 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

Comments (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