Re: MaxConnect response time

Mark wrote: > We set up a MaxConnect on IDS 9.3UC1 on AIX 5.1 plartform. We run a test > to compare the response time of direct connect DB and through MaxConnect. > > The test generate 150 concurrent users to run a simple select statement on > dbaccess. To complete the same job, MaxConnect take around 100 secs and > direct connect DB just take 15 secs. I has increased the WORKERTHREAD and > TRANSPORT value in MaxConnect but no improvement. > > I understand as MaxConnect is added between client and DB server and it will > need overhead, is it reasonable? > > Any experience or idea? I don't have that much experience, but I do know that MaxConnect is designed to reduce network traffic for more like 1500 users. I think you may well not see a benefit with only 150 users. Also, there are several architecture models you can use. IMNSHO, the only one that makes sense is to have MaxConnect running on your application server, thus reducing network traffic. This keeps the 1000's of user connections local, and multiplexes them down to a vastly reduced number over the network. If for example you were to run your database server, MaxConnect and application all on the same server (sometimes resources are not made available for testing), then I can imagine that MaxConnect will only introduce an additional overhead. Also, if your direct connection is not saturating the network, or running on a busy network, then you are not really testing the benefits that MaxConnect can provide. I could go on, suffice to say that benchmarking this type of setup should be done very carefully, or not at all. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list