Interesting! When we've tried to do the same, the time to login/logout/login again KILLED performance - and you had to do it for each 'piece' to stick to the letter of the law... Is UOJ somehow 'faster' at doing these Login/Out/In connections than other methods exposed by U2?
> -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug > Sent: Thursday, September 24, 2009 10:46 AM > To: 'U2 Users List' > Subject: [U2] Connection Pooling Statement > > George, > > We do not do connection pooling or use multiplexing software. > We have a connection manager written in Java to handle the > connections to Universe or Unidata. We adhere to our IBM > licensing agreement to the letter: one user one connection. > > Every call to the database requires a connection. After the > processing is done, the connection is released and available > for the next user. Since we use AJAX to make our calls, we > get lots of requests per second depending on the number of > users. If we run out of database licenses, then those > requests are queued up in our middleware called U2WebLink > until a connection is available or they hit the configurable > timeout parameter. > > 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. > > The technology does not have any connection manager software > written. It is a single license meant to used by .NET and > Web applications. > > Regards, > Doug > www.u2logic.com > > -----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 1:03 AM > To: U2 Users List > Subject: Re: [U2] Universe web connectivity > > On 24/09/2009 00:05, "Doug" <dave...@hotmail.com> wrote: > > > We do not require you to use IBM connection pooling since we handle > > this through UOJ and our connection manager. > > It's worth noting that if you use any software that > connection pools you are obliged to buy database connection > pooling licences. It doesn't matter whether you use the > connection pooling facilities they provide, from a legal and > commercial perspective you must buy them, you can't use > normal database licences. > > George Land > APT Solutions Ltd > > _______________________________________________ > 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