NodeJS/mongodb: Do I need to close db connection at some point?

Question

I read this article on connection pooling with mongodb/nodejs. There he opens the connection once, and leaves it at that.

This is how I set up the database connection in my app.js file:

mongodb.MongoClient.connect(MONGODB_URI, function (error, database) {
    if (error) throw error;

    db = database; // db is defined outside this callback
    coll = db.collection('testData'); // coll is defined outside this callback
});

This is going to leave the db connection open as long as the server is running. Shouldn't you close the connection at some point? Or is it of no consequence to leave it open?

Refer stackoverflow.com/questions/14495975/…

Damodaran
– Damodaran

2014-05-10 12:56:39 +00:00
Commented May 10, 2014 at 12:56 — Damodaran
– Damodaran, Commented May 10, 2014 at 12:56

JohnnyHK · Accepted Answer · 2014-05-10 12:58:39Z

4

If your app has support for controlled shutdown, then you should close the connection pool at that time. Otherwise you just leave it open.

The connection pool manages the number of actual connections for you, adding more in times of heavy load and closing them when your app is idle.

answered May 10, 2014 at 12:58

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ptf Over a year ago

What is a controlled shutdown? Is the connection pool built into the mongodb package?

JohnnyHK Over a year ago

@kjelelokk A controlled shutdown is just a general term for a program's support for closing in an orderly manner that ensures all outstanding operations have completed, as opposed to the default ctrl+c close. Yes, the standard MongoClient you reference above is a connection pool, not a single connection.

Collectives™ on Stack Overflow

NodeJS/mongodb: Do I need to close db connection at some point?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related