SQL fast in PSQL, very slow using MS.NET driver
От | Ashish Sharma |
---|---|
Тема | SQL fast in PSQL, very slow using MS.NET driver |
Дата | |
Msg-id | 002f01c89a42$1a117590$4e3460b0$@com обсуждение исходный текст |
Ответы |
Re: SQL fast in PSQL, very slow using MS.NET driver
|
Список | pgsql-hackers |
<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>
В списке pgsql-hackers по дате отправления: