David, I think your "problem" may be that you are logging only when you get a request? If you were to have lines pre-logged-in, though the complexity of the middleware increases, you may find a corresponding increase in performance ... and with a little more effort you may also decide to NOT kill a used connection immediately, 'cause if you get another request in from the same client "soon", shouldn't be an issue using the previously used connection (that is still open)
Ross Ferris Stamina Software Visage > Better by Design! >-----Original Message----- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Behalf Of David Wolverton >Sent: Friday, 25 September 2009 5:47 AM >To: 'U2 Users List' >Subject: Re: [U2] Connection Pooling Statement > >If you log off and on, it does satisfy the licensing - letter and >intent... >BUT usually the performance hit is so high that it FORCES you to >connection >pooling - or to have lots more seats! Both of which make IBM-Rocket >happy. ><g> > >I'm still wondering how they can get 175 users through 2 seats -- unless >each user does 2 things a day!! > >My understanding was that you either had to have a seat for each >'logical' >connection to a user, or sign off/sign on between each 'thing' - and the >overhead for going off and on is INSANE in any way I've tried to make it >work... > >So - I understand your point George -- I am in the same headspace! > >David W. > >> -----Original Message----- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land >> Sent: Thursday, September 24, 2009 2:32 PM >> To: U2 Users List >> Subject: Re: [U2] Connection Pooling Statement >> >> On 24/09/2009 16:45, "Doug" <dave...@hotmail.com> wrote: >> >> > George, >> > >> > We do not do connection pooling or use multiplexing software. >> >> I'm sorry, I didn't mean to imply that you did. I was trying >> to make a general point that you need connection pooling >> licences if you connection pool however you do it. >> > >> > We scale quite remarkable well. We have 70 user client >> running a call >> > center with 10 Unidata licenses dedicated to the web. We have a >> > public warehouse client with 4 licenses running 20 users internally >> > and 20 customers externally. We have a 175 user running our CRM >> > system using 2 licenses. >> > >> There is a general point here though, supporting 175 users on >> a 2 license system is exactly the situation IBM/Rocket are >> trying to address by forcing you to have connection pooling >> licences. Now don't misunderstand me, I'm not accusing you >> of breaking the letter of the license agreement, but I think >> it is breaking the intention of it. Quite what 'connection pooling' >> and 'multiplexing' really is can be debated, but essentially >> what they want is for you to pay more for databases licenses >> that support multiple users than you do that are tied to one >> user. And having a small number of database licenses >> supporting a large number of users is exactly what you are doing >> >> George >> >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > >_______________________________________________ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users