Mysql limitation

[dams]

Hi guys, i'am looking after a host for my coppermine gallery.

I've found a cheap hoster, but there is a limitation of 3 simultaneous connections to the sql db.


Is it enough for the installation ?


Is it enough in general considering I don't have a lot of visitors ?


Thanks for your help,

best regards.

[Nibbler]

If you never expect more than 3 users at the same then it will work just fine. I'm sure there are better options though, check the free web hosting thread in the general discussion board.

[dams]

Yes, it would be a problem if 3 users click exactly at the same time on a pic.

But, how long last a query ? 0.001 seconds ? 0.01 seconds ? Stop me if I'm wrong, but I thnik it's possible to have 10 or 15 simultaneous visitors wihout any problem ?

If a user launch a slideshow for example, is there a new query for each new pic ?


How about the installation ? Will it be fine with 3 query/sec ?


Thanks a lot for your help and happy new year !

[Joachim Müller]

It depends on many factors how long a query actually takes to run (traffic, coppermine layout and number of enabled features etc.). Installing won't be a problem. I suggest giving it a try and move to another webhost if you find out that the number of simultaneous connections is not enough. We can't predict the server power nor how you will configure coppermine.

[Nibbler]

Is the limitation 3 simultaneous connections or 3 queries per second? They are completely different. When a user visits the site the script will connect, run the queries, then disconnect. If you get more than 3 people loading pages simultaneously then people start getting error messages. When you run the installer you are only one person (with 1 connection) so the limit does not affect you. The sideshow preloads the pic data (in 1.4) so that will not be an issue.

[dams]

Here is the response I had from the support :

Bonjour,

Votre gallery photo va fonctionner avec une base de donnée et donc chaque fois que 3 personnes cliqueront simultannément sur une info de la base la 4éme personne recevra le message d'erreur indiquant qu'elle doit renouveller l'opération ultérieurement.

in english :

Your photo gallery will run on a database. Each time 3 users will click at the same time on a database info, the 4th user will ger an error message saying he must try later.