<div class="Section1"><p class="MsoNormal">Hi,<p class="MsoNormal">The setup in question includes PostGRESQL v8.2.4,
Javabased web servers and MS.NET based web servers. Following is the fuzzy situation:<p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l0level1 lfo2"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New
Roman""> </span></span>Our SQL queries run very fast using PSQL (both, from the server as well as the client).<p
class="MsoListParagraph"style="text-indent:-.25in;mso-list:l0 level1 lfo2"><span style="mso-list:Ignore">2.<span
style="font:7.0pt"Times New Roman""> </span></span>The Java app also retrieves the results very fast (of course,
weare using Postgres JDBC driver).<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><span
style="mso-list:Ignore">3.<spanstyle="font:7.0pt "Times New Roman""> </span></span>But, the same SQL queries
performpathetically slow when called from .NET application. The driver being used is NPGSQL.<p class="MsoNormal"> <p
class="MsoNormal">Ihave tried making some alterations to TCP related system variables like TCP_NoDelay and
TCPAckFrequencyon Windows, but to no profit. Same setup is already running on Oracle backend, and, there is no
differencein SQL response timings from either application.<p class="MsoNormal"> <p class="MsoNormal">Please advice, as
thishas become a major hurdle for us to push PostGRESQL to be productionized, in place of currently running Oracle
DB.<pclass="MsoNormal"> <p class="MsoNormal">Regards,<p class="MsoNormal"> <p class="MsoNormal">Ashish Sharma<p
class="MsoNormal">CoreDatabase Systems<p class="MsoNormal"><a
href="http://www.coredbsystems.com">http://www.coredbsystems.com</a></div><br/><p><font size="2">Internal Virus
Databaseis out-of-date.<br /> Checked by AVG.<br /> Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date:
4/2/20084:14 PM<br /></font>
