[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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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