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

[Solved] Slow performance on Windows .NET and OleDb

From: "Greg Quinn" <greg(at)officium(dot)co(dot)za>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: [Solved] Slow performance on Windows .NET and OleDb
Date: 2006-03-30 05:57:23
Message-ID: 000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

Responses

pgsql-performance by date

Next:From: Gavin HamillDate: 2006-03-30 08:26:13
Subject: CREATE INDEX rather sluggish
Previous:From: Josh BerkusDate: 2006-03-30 05:18:49
Subject: Re: Query using SeqScan instead of IndexScan

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