Menu
I'm using MongoDB Compass to perform an aggregation on a reasonably large dataset (~2,000,000 documents, 300MB) through an SSH tunnel.
It connects fine and I can query but stages in my pipeline appear to timeout operation exceeded time limit.
I know via the command line you can set the max time in milliseconds for a query using maxTimeMs $maxTimeMS but is it possible to apply this in MongoDB Compass?
I have also looked for connection timeout settings and can't find anything related to that in the GUI.
957
This error often occurs when: You provide no hostname or an invalid hostname to the Compass connect dialog. The destination server rejects a connection on an incorrect port. Your MongoDB cluster or server has been shutdown or the server hostname has changed.
What is the Compass Isolated Edition? Compass Isolated Edition restricts network requests to only the MongoDB server chosen on the Connect screen. All other outbound connections are not permitted in this edition, meaning no additional firewall configuration is required when running Compass Isolated Edition.
MongoDB Atlas belongs to "MongoDB Hosting" category of the tech stack, while MongoDB Compass can be primarily classified under "Database Tools". Some of the features offered by MongoDB Atlas are: Global clusters for world-class applications.
The Limit() Method To limit the records in MongoDB, you need to use limit() method. The method accepts one number type argument, which is the number of documents that you want to be displayed.
In Compass 1.19-beta we added an option to set maxTimeMS in the aggregation pipeline builder and in the query bar.
167
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
