CODEWITHSUNDEEP
mongodbpymongo
Nattelar
Nattelar

Reputation: 13

Can I reuse an connection in mongodb? How this connections actually work?

Trying to do some simple things with mongodb my mind got stuck in something that feels kinda strange for me.

client = MongoClient(connection_string)
db = client.database
    
print(db)
    
client.close()

I thought that when make a connection it is used only this one along the rest of the code until the close() method. But it doesn't seem to work that way... I don't know how I ended up having 9 connections when it supposed to be a single one, and even if each 'request' is a connection there's too many of them

connection status

For now it's not a big problem, just bothers me the fact that I don't know exactly how this works!

Upvotes: 0

Views: 1782

Answers (2)

noam
noam

Reputation: 578

According to the documentation, you should create one client per process.

Your code seems to be the correct way if it is a single thread process. If you don't need any more connections to the server, you can limit the pool size by explicitly specifying the number:

client = MongoClient(host, port, maxPoolSize=<num>).

On the other hand, if the code might later use the same connection, it is better to simply create the client once in the beginning, and use it across the code.

Upvotes: 0

Yahya
Yahya

Reputation: 3444

When you do new MongoClient(), you are not establishing just one connection. In fact you are creating the client, that will have a connection pool. When you do one or multiple requests, the driver uses an available connection from the pool. When the use is complete, the connection goes back to the pool.

Calling MongoClient constructor every time you need to talk to the db is a very bad practice and will incur a penalty for the handshake. Use dependency injection or singleton to have MongoClient.

Upvotes: 2

Related Questions