Why set the min to 5. That means during non peak time your database still needs to cary the load of the 5 connections. I think that two or three connections is fine for the min
----- Original Message ----- From: "Rainer Jünger" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 10:21 AM Subject: Re: data-sources configuration > > Thanks for the confirmation! > In general the context is clear to me. I just wanted to have some figures. > Actually, how many connections a MySQL can handle? Do you use something like > 5 and 40 or is that already to high? I need a startingpiont wherefrom I can > begin my experiments ; ) > > thanks rainer > > > > you are correct about min/max. As to the values, that's going to be > > subjective. If you don't want your users to fail, then your max better be > > as large as your concurrent users. The min is trickier. You need to > > balance your resources against response. If you are feeling that the > > response is OK even with a low number then I don't see the point of having > > more than a couple for the min. > > > > > -----Original Message----- > > > From: Rainer Jünger [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, May 07, 2002 2:33 AM > > > To: Struts Users Mailing List > > > Subject: data-sources configuration > > > > > > > > > Hi, > > > > > > we are using the pooling of Struts. I know there are better > > > ones. But we think it should do before the new release(1.1) is out. > > > I am having a question on two attributes within the > > > data-source tag of the struts-config.xml file > > > > > > 1) There are two values to be set: > > > maxCount="40" > > > minCount="5" > > > Is it right that minCount means the minimum number of pooled > > > connections which are always provided and maxCount is the > > > maximum number of connections? > > > > > > 2) How can I find out about the best configuration? Are there > > > any values out of your experiance you can give? > > > > > > thanks Rainer > > > > > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
