Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Connection pool

  • nicolabraccini
  • nicolabraccini's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 months ago #127761 by nicolabraccini
Connection pool was created by nicolabraccini
Hi,
is possible to manage connection pool?

thank you.
n.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 4 months ago #127764 by holch
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
  • nicolabraccini's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 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.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 4 months ago #127782 by DenisChenu
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

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.

Lime-years ahead

Online-surveys for every purse and purpose