This is a multipart message in MIME format.
------=_NextPart_000_001C_01C89A54.3E92FD50
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: 7bit
Hi,
The setup in question includes PostGRESQL v8.2.4, Java based web servers
and
MS.NET based web servers. Following is the fuzzy situation:
1. Our SQL queries run very fast using PSQL (both, from the server
as
well as the client).
2. The Java app also retrieves the results very fast (of course, we
are using Postgres JDBC driver).
3. But, the same SQL queries perform pathetically slow when called
from .NET application. The driver being used is NPGSQL.
I have tried making some alterations to TCP related system variables like
TCP_NoDelay and TCPAckFrequency on Windows, but to no profit. Same setup
is
already running on Oracle backend, and, there is no difference in SQL
response timings from either application.
Please advice, as this has become a major hurdle for us to push PostGRESQL
to be productionized, in place of currently running Oracle DB.
Regards,
A****sh Sharma
Core Database Systems
HYPERLINK "http://www.coredbsystems.com"http://www.coredbsystems.com
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date: 4/2/2008
4:14 PM
------=_NextPart_000_001C_01C89A54.3E92FD50
Content-Type: text/html;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
=
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dwindows-1250">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@[EMAIL PROTECTED]
15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:ex****t-only;
font-size:10.0pt;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@[EMAIL PROTECTED]
l0
{mso-list-id:1643268629;
mso-list-type:hybrid;
mso-list-template-ids:-317404068 67698703 67698713 67698715 67698703 =
67698713 67698715 67698703 67698713 67698715;}
@[EMAIL PROTECTED]
l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@[EMAIL PROTECTED]
l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal>Hi,<o:p></o:p></p>
<p class=3DMsoNormal>The setup in question includes PostGRESQL v8.2.4, =
Java based
web servers and MS.NET based web servers. Following is the fuzzy =
situation:<o:p></o:p></p>
<p class=3DMsoListParagraph style=3D'text-indent:-.25in;mso-list:l0 =
level1 lfo2'><![if !sup****tLists]><span
style=3D'mso-list:Ignore'>1.<span style=3D'font:7.0pt "Times New =
Roman"'>
</span></span><![endif]>Our SQL queries run very fast using PSQL (both, =
from
the server as well as the client).<o:p></o:p></p>
<p class=3DMsoListParagraph style=3D'text-indent:-.25in;mso-list:l0 =
level1 lfo2'><![if !sup****tLists]><span
style=3D'mso-list:Ignore'>2.<span style=3D'font:7.0pt "Times New =
Roman"'>
</span></span><![endif]>The Java app also retrieves the results very =
fast (of
course, we are using Postgres JDBC driver).<o:p></o:p></p>
<p class=3DMsoListParagraph style=3D'text-indent:-.25in;mso-list:l0 =
level1 lfo2'><![if !sup****tLists]><span
style=3D'mso-list:Ignore'>3.<span style=3D'font:7.0pt "Times New =
Roman"'>
</span></span><![endif]>But, the same SQL queries perform pathetically =
slow
when called from .NET application. The driver being used is =
NPGSQL.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I have tried making some alterations to TCP =
related
system variables like TCP_NoDelay and TCPAckFrequency on Windows, but to =
no
profit. Same setup is already running on Oracle backend, and, there is =
no
difference in SQL response timings from either =
application.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Please advice, as this has become a major hurdle =
for us to
push PostGRESQL to be productionized, in place of currently running =
Oracle DB.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Regards,<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>A****sh Sharma<o:p></o:p></p>
<p class=3DMsoNormal>Core Database Systems<o:p></o:p></p>
<p class=3DMsoNormal><a =
href=3D"http://www.coredbsystems.com">http://www.coredbsystems.com</a>
<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=3D2>No virus found in this outgoing message.<BR>
Checked by AVG.<BR>
Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date: =
4/2/2008 4:14 PM<BR>
</FONT> </P>
------=_NextPart_000_001C_01C89A54.3E92FD50--
|
