From: Jim C. Nasby <jnasby@pervasive.com>
To: Greg Quinn <greg@officium.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow performance on Windows .NET and OleDb
Date: Tue, 28 Mar 2006 11:32:13 -0600
Message-ID: <20060328173213.GO75181@pervasive.com> (raw)
In-Reply-To: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za>
References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za>
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@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jnasby@pervasive.com, greg@officium.co.za
Subject: Re: Slow performance on Windows .NET and OleDb
In-Reply-To: <20060328173213.GO75181@pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox