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

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

From: "Dave Dutcher" <dave(at)tridecap(dot)com>
To: "'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-30 14:34:23
Message-ID: 002a01c65407$0a302730$ (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
I use Npgsql, and the connection string I use is real simple:

Server=;Database=mydb;User Id=myuserid;Password=123456

Hope that helps,


> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> 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
> .net driver please? I'm battling to find a valid connection string.
> Thanks
> ---------------------------(end of
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that
>        message can get through to the mailing list cleanly

In response to


pgsql-performance by date

Next:From: Peter EisentrautDate: 2006-03-30 15:16:13
Subject: Re: Index scan startup time
Previous:From: Tom LaneDate: 2006-03-30 14:25:57
Subject: Re: Index scan startup time

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