Connection pool

Plus d'informations
il y a 2 ans 10 mois #127761 par nicolabraccini
nicolabraccini a créé le sujet : Connection pool
Hi,
is possible to manage connection pool?

thank you.
n.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 10 mois #127764 par holch
holch a répondu au sujet : 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

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 10 mois #127769 par nicolabraccini
nicolabraccini a répondu au sujet : 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.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 2 ans 10 mois #127782 par DenisChenu
DenisChenu a répondu au sujet : 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 .

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!