[Solved] Slow performance on Windows .NET and OleDb

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-performance@xxxxxxxxxxxxxx>
Subject: [Solved] Slow performance on Windows .NET and OleDb
From: "Greg Quinn" <greg@xxxxxxxxxxxxxx>
Date: Thu, 30 Mar 2006 07:57:23 +0200
References: <000d01c65261$19a3fa40$0200a8c0@xxxxxxxxxxxxxxx> <20060328173213.GO75181@xxxxxxxxxxxxx> <442977D7.5060508@xxxxxxxxxxxxxxxxx> <006c01c652f9$1ca9c420$0200a8c0@xxxxxxxxxxxxxxx> <op.s653ebg3cigqcu@apollo13> <000f01c6531f$fcbc0570$0200a8c0@xxxxxxxxxxxxxxx> <442B3282.8070204@xxxxxxxxxxxxxxx>
Reply-to: "Greg Quinn" <greg@xxxxxxxxxxxxxx>

This problem was caused by the OleDb driver. I used a 3rd party .NETprovider 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

Follow-Ups:
- Re: [Solved] Slow performance on Windows .NET and OleDb
  - From: Dave Dutcher

References:
- Slow performance on Windows .NET and OleDb
  - From: Greg Quinn
- Re: Slow performance on Windows .NET and OleDb
  - From: Jim C. Nasby
- Re: Slow performance on Windows .NET and OleDb
  - From: Joshua D. Drake
- Re: Slow performance on Windows .NET and OleDb
  - From: Greg Quinn
- Re: Slow performance on Windows .NET and OleDb
  - From: Greg Quinn
- Re: Slow performance on Windows .NET and OleDb
  - From: Christopher Kings-Lynne

Prev by Date: Re: Query using SeqScan instead of IndexScan
Next by Date: CREATE INDEX rather sluggish
Previous by thread: Re: Slow performance on Windows .NET and OleDb
Next by thread: Re: [Solved] Slow performance on Windows .NET and OleDb
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux