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: > > > > 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. > > > > What queries are you running? What version of Npgsql? Are you using prepared statements? We have performance issues with prepared statements. If it is so, can you try without prepared statements? You can discuss this also in our forums: forums.npgsql.org Thanks in advance. -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
