informix 9.4 question: PDQPRIORITY and user threads
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C31F07.D165AEC0
Content-Type: text/plain;
charset="iso-8859-1"
We are testing IDS 9.4 against linux Red Hat 7.2. Converting DB from
IDS 7.31 on HP-UX.
We have PDQPRIORITY set to 1 for most of our 4gl applications. When
I do an onstat -u, I am seeing multiple user threads (sometimes 120) per
session. This type of high multi-threading does not occur with the same
PDQPRIORITY on IDS 7.31. In my testing, I have been setting the PDQPRIORITY
back to zero. This limits the user threads to one per session. And the
application performance does not seem affected. I am assuming since the 4gls
are programmed inline, with no forking, that using multiple user threads is
not helping.
Has anyone else run into this issue?
Mark Roach
IT - Programmer/Analyst
Strategic Outsourcing, Inc.
------_=_NextPart_001_01C31F07.D165AEC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>informix 9.4 question: PDQPRIORITY and user threads</TITLE>
</HEAD>
<BODY>
<BR>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">We are testing IDS 9.4 against linux Red Hat 7.2. =
Converting DB from IDS 7.31 on HP-UX.</FONT>
</P>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">We have PDQPRIORITY set to 1 for most of our 4gl =
applications. When I do an onstat -u, I am seeing multiple user threads =
(sometimes 120) per session. This type of high multi-threading does not =
occur with the same PDQPRIORITY on IDS 7.31. In my testing, I have been =
setting the PDQPRIORITY back to zero. This limits the user threads to =
one per session. And the application performance does not seem =
affected. I am assuming since the 4gls are programmed inline, with no =
forking, that using multiple user threads is not helping.</FONT></P>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">Has anyone else run into this issue?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Mark Roach</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">IT - Programmer/Analyst</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Strategic Outsourcing, Inc.</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C31F07.D165AEC0--