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

Re: Slow performance on Windows .NET and OleDb

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Greg Quinn <greg(at)officium(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow performance on Windows .NET and OleDb
Date: 2006-03-28 17:32:13
Message-ID: 20060328173213.GO75181@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Mar 28, 2006 at 02:14:00PM +0200, Greg Quinn wrote:
> 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 worse is displaying the 3000 records in a ListView control. It takes 
> about 7 seconds. In MySQL, the exact same table and application displays 
> the same 3000 records in under 1/2 second!!!

Have you vacuumed recently? This smells like it might be a table bloat
problem.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2006-03-28 17:34:43
Subject: Re: simple join uses indexes, very slow
Previous:From: Jim C. NasbyDate: 2006-03-28 17:30:47
Subject: Re: simple join uses indexes, very slow

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