Re: Slow Connection - HP 11 9.30

Sebastian, Norma J. wrote: > Brian, > > Did something get garbled in your post? > Your ONCONFIG shows: > NETTYPE # Configure poll thread(s) for nettype> > If you don't have NETTYPE set, maybe that's the problem. > I don't know what the default is for NETTYPE, you could probably find > that in the online docs or someone out here would know. > > I do know in general this is related to how many connections the DB can > take. > My NETTYPE settings are : > NETTYPE ipcshm,8,89,NET > NETTYPE tlitcp,9,100,CPU> Which, if my rusty knowledge is accurate means I have 8 poll threads for > shared memory connections, each of the 8 poll threads can handle 89 > connections. > My network connection (tlitcp) has 9 dedicated poll threads, each > capable of handling 100 connections. Norma, read my notes on setting NETTYPE in the FAQ. The configuration you have will tend to be responsive to shared memory sessions & new shared memory connection requests, but will burn CPU cycles and system call overhead like crazy and be slower to respond to TCP sessions and new TCP connections under load. You could free up lots of resources and be even more responsive to both connection types by floowing those recommendations. Art S. Kagel