Questions tagged [connection-pool]
In software engineering, a connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required. Connection pools are used to enhance the performance of executing commands on a database.
30 questions
1
vote
0
answers
75
views
Connection pool design for Boost MySQL
I had to design a connection pool that handles Boost MySQL connection to use the asynchronous functions.
Here is the code:
...
- 41
2
votes
1
answer
867
views
Parallel handling db queries is very slow in C#
I have SignalR app that publishes sent messages to Redis. My console app subscribe to channel where these messages are sent, deserializes it and saves in database.
Problem is with handling these ...
- 171
1
vote
2
answers
4k
views
Simple Connection Pool for SQLite in Python
When I talk to people regarding connection pooling in SQLite most of them always laugh and say "You don't know about SQLite", "It is not a client server DB, and only overhead in ...
- 113
0
votes
1
answer
122
views
Implementing Database Connection Pooling
I am re-implementing a web-application, partially as a learning exercise to learn nim as well as multi-threaded programming. As part of that learning exercise, I want to implement connection pooling ...
- 545
2
votes
1
answer
902
views
golang http.Client wrapper with rate and concurrency limiting
My goal is to safely consume an API without getting 429 Too Many Requests error, activating DDoS protection or going over system limit of maximum open file ...
- 151
2
votes
0
answers
400
views
Delphi TIdTCPClient connection pool in a multithread environment
I want to use TIdTCPClient to connect to Redis from a web server application made with Delphi and TWebModule. Currently on ...
- 201
3
votes
3
answers
140
views
6
votes
1
answer
1k
views
Simple Connection Pooling with psycopg2 and PostgreSQL
I am currently using a SimpleConnectionPool from psycopg2 to lease transactions to a PostgreSQL database and would like a review ...
- 221
3
votes
0
answers
87
views
Providing a connection pool
I need some opinions about method naming and single responsibility principle.
First of all, let's talk about method naming. The class below was created to provide a connection pool and whenever a pool ...
- 131
1
vote
1
answer
152
views
Using MySQL with Wai and Warp
I was wondering if below is the correct convention for combining Wai with a Database pool.
What I basically do is, create a pool, partially apply a function of type ...
- 119
2
votes
0
answers
429
views
Wrapper for sql.Connection
I wrote wrapper for Connection. It uses my Connection pool implementation. When the wrapper closes, the connection goes back to pool.
...
- 163
6
votes
2
answers
2k
views
Connection Pool in Java 8 using Strategy and Factory Pattern
How can I improve the following code and features?
It is based on active911's C++ connection pool.
The full code and unit tests are here : https://github.com/spakai/connection_pool
the README ...
- 183
9
votes
2
answers
1k
views
C++11 Blocking connection pool with auto release
Relatively new to C++. Please help me understand the potential issues with the following blocking object pool.
...
- 189
4
votes
1
answer
1k
views
Pool of curl handles
I am trying to write a simple reusable pool of curl handles. I found this wonderful implementation of the blocking queue.
The pool itself looks like this:
...
- 143
2
votes
0
answers
510
views
Concurrent SSH session pool
In my application I need to perform several SSH commands from Windows to a Linux machine.
Since I need to reduce as much as possible the SSH calls overhead and also limit the number of concurrent ...
- 121