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. > > >

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 > > > sit

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 >

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

[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 fast