Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: dams on December 30, 2006, 06:36:46 PM

Title: Mysql limitation
Post by: dams on December 30, 2006, 06:36:46 PM
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.
Title: Re: Mysql limitation
Post by: Nibbler on December 30, 2006, 11:14:25 PM
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.
Title: Re: Mysql limitation
Post by: dams on December 31, 2006, 12:44:01 PM
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 !
Title: Re: Mysql limitation
Post by: Joachim Müller on December 31, 2006, 01:06:42 PM
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.
Title: Re: Mysql limitation
Post by: Nibbler on December 31, 2006, 01:10:54 PM
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.
Title: Re: Mysql limitation
Post by: dams on December 31, 2006, 01:47:24 PM
Here is the response I had from the support :

QuoteBonjour,

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.
Text only | Text with Images