Re: dbaccess connect time difference between onipcshm and onsoctcp

Yaşar Akman said: > Hi Everyone, > > We have informix database in tru64 unix that has shared memory and tcp > connection(onipcshm, onsoctcp) . > > 10 connection through shm takes 20 seconds. > 10 connection through tcp takes less than 5 seconds. > > I was expecting shm would be faster, in fact it is not. > > Is there a something wrong in informix or tru64 unix configuration. onstat -c | grep -i nettype onstat -g ntu onstat -g ntt Post the results. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list

t1:/>onstat -c | grep -i nettype NETTYPE ipcshm,1,100,CPU # Override sqlhosts nettype parameters NETTYPE soctcp,1,100,NET # Override sqlhosts nettype parameters t1:/>onstat -g ntu IBM Informix Dynamic Server Version 9.40.FC2X2 -- On-Line -- Up 19:42:34 -- 385024 Kbytes global network information: #netscb connects read write q-free q-limits q-exceed alloc/max 6/ 7 108 20245 60548 1/ 1 170/ 10 0/ 0 1/ 1 Individual thread network information (basic): netscb type thread name sid fd poll reads writes q-nrm q-pvt q-exp 215dc0c78 soctcp soctcplst 8 2 5 0 0 0/ 0 0/ 0 0/ 0 215dbec28 soctcp soctcplst 7 1 5 42 0 0/ 0 0/ 0 0/ 0 215dbe3b0 ipcshm sm_discon 6 0 0 0 0 0/ 0 0/ 0 0/ 0 215dafc50 ipcshm sm_listen 4 0 0 66 0 0/ 0 0/ 0 0/ 0 215d9b5d0 soctcp soctcppoll 3 0 5 5880 0 0/ 0 0/ 0 0/ 0 215d875d0 ipcshm sm_poll 2 0 0 14378 0 0/ 0 0/ 0 0/ 0 t1:/>onstat -g ntt IBM Informix Dynamic Server Version 9.40.FC2X2 -- On-Line -- Up 19:42:44 -- 385024 Kbytes global network information: #netscb connects read write q-free q-limits q-exceed alloc/max 6/ 7 108 20245 60548 1/ 1 170/ 10 0/ 0 1/ 1 Individual thread network information (times): netscb thread name sid open read write address 215dc0c78 soctcplst 8 13:16:47 t1|1641|soctcp 06/22/05 215dbec28 soctcplst 7 13:16:47 17:02:59 t1|1541|soctcp 06/22/05 06/22/05 215dbe3b0 sm_discon 6 13:16:47 06/22/05 215dafc50 sm_listen 4 13:16:47 06/22/05 215d9b5d0 soctcppoll 3 13:16:47 06/22/05 215d875d0 sm_poll 2 13:16:47 06/22/05