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$8300a8c0@tridecap.com (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

Responses

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-2014 The PostgreSQL Global Development Group