From: Antoine <melser.anton@gmail.com>
To: Dave Dutcher <dave@tridecap.com>
Cc: Greg Quinn <greg@officium.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
Date: Fri, 31 Mar 2006 22:49:10 +0200
Message-ID: <92d3a4950603311249n5eb1e26maa9d0777d6ec70cf@mail.gmail.com> (raw)
In-Reply-To: <002a01c65407$0a302730$8300a8c0@tridecap.com>
References: <000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za>
<002a01c65407$0a302730$8300a8c0@tridecap.com>
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@tridecap.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@postgresql.org
> [mailto:pgsql-performance-
> > owner@postgresql.org] On Behalf Of Greg Quinn
> > Sent: Wednesday, March 29, 2006 11:57 PM
> > To: pgsql-performance@postgresql.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@postgresql.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: melser.anton@gmail.com, dave@tridecap.com, greg@officium.co.za
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
In-Reply-To: <92d3a4950603311249n5eb1e26maa9d0777d6ec70cf@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox