pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Greg Quinn <greg@officium.co.za>
To: pgsql-performance@postgresql.org
Subject: [Solved] Slow performance on Windows .NET and OleDb
Date: Thu, 30 Mar 2006 07:57:23 +0200
Message-ID: <000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za> (raw)
References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za>
	<20060328173213.GO75181@pervasive.com>
	<442977D7.5060508@commandprompt.com>
	<006c01c652f9$1ca9c420$0200a8c0@pta.homex.co.za>
	<op.s653ebg3cigqcu@apollo13>
	<000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za>
	<442B3282.8070204@calorieking.com>

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

view thread (19+ messages)  latest in thread

Message-ID: <000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za>
Permalink:  ../000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za/
Also on:    postgresql.org/message-id/000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za

copy link · copy postgr.es

reply

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: greg@officium.co.za
  Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
  In-Reply-To: <000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za>

* 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