Re: [HACKERS] SQL fast in PSQL, very slow using MS.NET driver

2008-04-10 Thread Ashish Sharma
Thanks for the response. Below are the details: On Wed, 2008-04-09 at 18:33 +0530, Ashish Sharma wrote: Hi, Hi, all!! The setup in question includes PostGRESQL v8.2.4, Java based web servers and MS.NET based web servers. Following is the fuzzy situation:

Re: [HACKERS] SQL fast in PSQL, very slow using MS.NET driver

2008-04-10 Thread Francisco Figueiredo Jr.
On Thu, Apr 10, 2008 at 5:27 AM, Ashish Sharma [EMAIL PROTECTED] wrote: Thanks for the response. Below are the details: What queries are you running? We are running normal SQLs and DMLs. Even simple queries like select * from... are showing the described behavior. What version

[HACKERS] SQL fast in PSQL, very slow using MS.NET driver

2008-04-09 Thread Ashish Sharma
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

Re: [HACKERS] SQL fast in PSQL, very slow using MS.NET driver

2008-04-09 Thread Hannu Krosing
On Wed, 2008-04-09 at 18:33 +0530, Ashish Sharma wrote: 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

Re: [HACKERS] SQL fast in PSQL, very slow using MS.NET driver

2008-04-09 Thread Francisco Figueiredo Jr.
On Wed, Apr 9, 2008 at 10:56 AM, Hannu Krosing [EMAIL PROTECTED] wrote: On Wed, 2008-04-09 at 18:33 +0530, Ashish Sharma wrote: Hi, Hi, all!! The setup in question includes PostGRESQL v8.2.4, Java based web servers and MS.NET based web servers. Following is the fuzzy situation: