Announcement

#1 2009-03-10 21:02:10

voyteckst
Translation Team
2009-01-11
20

Piwigo and max db connections [RESOLVED]

Hi,

My hosting provider allows only 3 max db connections. So I have question - how does it affect piwigo? OR rather how many users will it support concurrently?

Regards,
voyteckst

Last edited by voyteckst (2009-03-10 22:53:54)

Offline

 

#2 2009-03-10 21:58:25

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7201

Re: Piwigo and max db connections [RESOLVED]

Neighborhood 20 visitors at the same time


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#3 2009-03-10 22:10:11

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13786

Re: Piwigo and max db connections [RESOLVED]

To get an idea for your hosting, turn on the "display generation time" setting : with [Administration>Specials>Plugins>LocalFiles Editor] (install & activate the plugin), in the "Local Config", add:

Code:

$conf['show_gt'] = true;

This will display the generation time at the bottom of every page. For example, you'll see something like "0.098 s" and you can consider that a visitor stay on the same page during 5 seconds. Every 5 seconds, a database connection is used during 0.1s. That should let many users come in the same time :-)

Offline

 

#4 2009-03-10 22:42:21

voyteckst
Translation Team
2009-01-11
20

Re: Piwigo and max db connections [RESOLVED]

So I have: Page generated in 0.435 s (21 SQL queries in 0.065 s) .

Offline

 

#5 2009-03-10 22:46:24

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13786

Re: Piwigo and max db connections [RESOLVED]

voyteckst wrote:

So I have: Page generated in 0.435 s (21 SQL queries in 0.065 s) .

It is quite a big duration, your server seems to be resource limited :-) It doesn't really matter, Piwigo is very reasonable concerning required resources.

I would say that 10 simultaneous visitors should be fine.

Offline

 

#6 2009-03-10 22:52:23

voyteckst
Translation Team
2009-01-11
20

Re: Piwigo and max db connections [RESOLVED]

Some pages are generated  also in (for example) 0.197 s (12 sql in 0.012 s). But generally I understand. Thanks.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact