From: Dave Dutcher <dave@tridecap.com>
To: 'Greg Quinn' <greg@officium.co.za>
To: pgsql-performance@postgresql.org
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
Date: Thu, 30 Mar 2006 08:34:23 -0600
Message-ID: <002a01c65407$0a302730$8300a8c0@tridecap.com> (raw)
In-Reply-To: <000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za>
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
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: dave@tridecap.com, greg@officium.co.za
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
In-Reply-To: <002a01c65407$0a302730$8300a8c0@tridecap.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