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: > > > > > > 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? We are running normal SQLs and DMLs. Even simple queries like "select * from..." are showing the described behavior. > What version of Npgsql? NPGSQL ver. 1.97.1.0 > > Are you using prepared statements? We have performance issues with > prepared statements. If it is so, can you try without prepared > statements? We are not you prepared statements. > > You can discuss this also in our forums: > > forums.npgsql.org > The dotNet version we are using is 2.0, PostgreSQL 8.2.4 (on RHEL4) Appreciate the support. Regards, Ashish Sharma No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.11 - Release Date: 4/9/2008 12:00 AM -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
