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
--
g Ram. Windows XP
- Original Message -
From: "PFC" <[EMAIL PROTECTED]>
To: "Greg Quinn" <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2006 11:02 AM
Subject: Re: [PERFORM] Slow performance on Windows .NET and OleDb
select * from users
which returns 4 var
Via insert
When you do the population, is it via inserts or copy?
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 19
give me some tips?
Thanks
- Original Message -
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Jim C. Nasby" <[EMAIL PROTECTED]>
Cc: "Greg Quinn" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 28, 2006 7:52 PM
Subject: Re: [PERFORM] Slow perfo
Hello,
I have just installed PostGreSql 8.1 on my Windows XP PC. I created a simple
table called users with 4 varchar fields.
I am using the OleDb connection driver. In my .NET application, I populate
3000 records into the table to test PostGreSql's speed. It takes about 3-4
seconds.
Even
