- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Connection pool
- nicolabraccini
- Topic Author
- Offline
- New Member
Less
More
8 years 5 months ago #127761
by nicolabraccini
Connection pool was created by nicolabraccini
Hi,
is possible to manage connection pool?
thank you.
n.
is possible to manage connection pool?
thank you.
n.
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11645
- Thank you received: 2738
8 years 5 months ago #127764
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Connection pool
What is meant with connection pool?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- nicolabraccini
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
8 years 5 months ago #127769
by nicolabraccini
Replied by nicolabraccini on topic Connection pool
I mean if lime has a pool where to manage db connections. For example can I set in lime a maximum simultaneous connection to the db and the minumum connection always open to use?
What happens when 1000 users access the survey simultaneously and the db has only 100 open connections?
Can lime opens more connections than those configured in the database?
n.
What happens when 1000 users access the survey simultaneously and the db has only 100 open connections?
Can lime opens more connections than those configured in the database?
n.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13624
- Thank you received: 2490
8 years 5 months ago #127782
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Connection pool
Like all PHP/SQL system : we need connection when we need it, not a connexion by user.
If you have 100 user at a time on a survey : in general you don't need 100 connexion, but between 5 and 20 (completely by noise : depend on survey complexity).
Each page produced by PHP wait for open conexion : if you have little connexion pool and a lot of user : PHP production is more long.
But : if you need more connexion : you have to see with your hoster. f you are on your server : it can be unlimited.
LimeSurvey can not open more connexion than DB configuration .... we are not magician.
Denis
If you have 100 user at a time on a survey : in general you don't need 100 connexion, but between 5 and 20 (completely by noise : depend on survey complexity).
Each page produced by PHP wait for open conexion : if you have little connexion pool and a lot of user : PHP production is more long.
But : if you need more connexion : you have to see with your hoster. f you are on your server : it can be unlimited.
LimeSurvey can not open more connexion than DB configuration .... we are not magician.
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.