Re: IDS 11.7 Tuning help

Thanks John - I do already have the cache set up.. NETTYPE soctcp,40,100,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 NUMFDSERVERS 4 NS_CACHE host=900,service=900,user=900,group=900 I will try increasing the number of listeners for the port... Laurie On Wed, Jan 9, 2013 at 1:02 PM, John Miller iii <miller3@us.ibm.com> wrote: > Laurie: > > I would suggest a few of the following. First utilize the new cache > capability this will reduce the number of network calls to the operating > system. Second, make sure FASTPOLLing is enabled. Ensure you have more > than one FD server to spread the load around. > > NS_CACHE host=900,service=900,user=900,group=900 > FASTPOLL 1 > NUMFDSERVERS 4> > In addition, I would look at using multiple listener threads for the same > port. This is done by simply adding > a (-count) to the end of the Informix server name in the onconfig. The > example below will start 3 listener threads > all servicing the port associated with the "blazer". > > > > DBSERVERNAME blazer-3> > Hope this helps, > John F. Miller III > > > informix-list-bounces@iiug.org wrote on 01/09/2013 11:47:38 AM: > > > From: Laurie Gustin <lgustin@utah.gov> > > To: informix-list@iiug.org, > > Cc: Mike Sadler <MSADLER@utah.gov>, "Kennedy, Bevis" <bkennedy@utah.gov> > > Date: 01/09/2013 11:48 AM > > Subject: IDS 11.7 Tuning help > > Sent by: informix-list-bounces@iiug.org > > > > > We have recently migrated from IDS 11.5 to IDS11.70 FC5 instance > > running on Linux. We have one application that makes many separate > > connections to the database. They connect, run small queries and > > disconnect. The queries usually take less than one second, so these > > connections come and go very quickly and there are alot of them. > > > > We are experiencing some slowness on the 11.7 server that we did not > > see on 11.5, so I'm looking for help getting this new server tuned > > up. The only think I know to look at is NETTYPE params > > > > 11.5 - NETTYPE soctcp, 50, 100, NET - when I start this engine I > > get this error: Warning: Number of poll threads for nettype soctcp > > has already reached the maximum of 50 > > 11.7 - NETTYPE soctcp, 40, 100, NET > > > > Thanks in advance! > > > > Laurie_______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > >