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