Re: IDS 11.7 Tuning help

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