Skip site navigation (1) Skip section navigation (2)

Re: [Solved] Slow performance on Windows .NET and OleDb

From: Antoine <melser(dot)anton(at)gmail(dot)com>
To: "Dave Dutcher" <dave(at)tridecap(dot)com>
Cc: "Greg Quinn" <greg(at)officium(dot)co(dot)za>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
Date: 2006-03-31 20:49:10
Message-ID: 92d3a4950603311249n5eb1e26maa9d0777d6ec70cf@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
This is a blatant thread steal... but here we go...
Do people have any opinions on the pgsql driver? How does it compare
with the odbc in terms of performance? Is it fully production ready?
The boss wants to go .net (instead of Java, which is my preference...)
- will I have to spend my time defending postgres against
mysql/postgres/sqlserver?
Cheers
Antoine
ps. I try my best not to steal threads but sometimes... :-)

On 30/03/06, Dave Dutcher <dave(at)tridecap(dot)com> wrote:
> I use Npgsql, and the connection string I use is real simple:
>
> Server=192.168.0.36;Database=mydb;User Id=myuserid;Password=123456
>
> Hope that helps,
>
> Dave
>
> > -----Original Message-----
> > From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-
> > owner(at)postgresql(dot)org] On Behalf Of Greg Quinn
> > Sent: Wednesday, March 29, 2006 11:57 PM
> > To: pgsql-performance(at)postgresql(dot)org
> > Subject: [PERFORM] [Solved] Slow performance on Windows .NET and OleDb
> >
> > This problem was caused by the OleDb driver. I used a 3rd party .NET
> > provider and it worked, 8000 rows in just over 100ms!
> >
> > Can somebody send me a sample connection string for the PostGreSql
> native
> > .net driver please? I'm battling to find a valid connection string.
> >
> > Thanks
> >
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> >        message can get through to the mailing list cleanly
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--
This is where I should put some witty comment.

In response to

pgsql-performance by date

Next:From: Magnus HaganderDate: 2006-03-31 23:27:15
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
Previous:From: Tom LaneDate: 2006-03-31 16:27:10
Subject: Re: un-'vacuum analyse'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group