Connection pool

More
2 years 8 months ago #127761 by nicolabraccini
nicolabraccini created the topic: Connection pool
Hi,
is possible to manage connection pool?

thank you.
n.

Please Log in or Create an account to join the conversation.

More
2 years 8 months ago #127764 by holch
holch replied the topic: Connection pool
What is meant with connection pool?

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
2 years 8 months ago #127769 by nicolabraccini
nicolabraccini replied the 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.

Please Log in or Create an account to join the conversation.

More
2 years 8 months ago #127782 by DenisChenu
DenisChenu replied the 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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!