how many rows does it return ? a few, or a lot ?
3000 Rows - 7 seconds - very slow
Which client library may have a problem? I am using OleDb, though haven't
tried the .NET connector yet.
Network configuration?? I am running it off my home PC with no network. It
is P4 2.4 with 1 Gig Ram. Windows XP
----- Original Message -----
From: "PFC" <lists@xxxxxxxxxx>
To: "Greg Quinn" <greg@xxxxxxxxxxxxxx>
Sent: Wednesday, March 29, 2006 11:02 AM
Subject: Re: [PERFORM] Slow performance on Windows .NET and OleDb
select * from users
which returns 4 varchar fields, there is no where clause
how many rows does it return ? a few, or a lot ?
Yes, I am running the default postgres config. Basically I have been a
MySQL user and thought I would like to check out PostGreSql.
Good idea...
From the tests I made, on simple queries like yours, with no joins, speed
pf pg 8.x is about the same as mysql 5.x ; that is to say very fast. If
you have a performance problem on something so basic, and moreover on
windows, it smells like a problem in the client library, or in the TCP
transport between client and server.
I remember messages saying postgres on windows was slow some time ago
here, and it turned out to be a problem in the network configuration of
the machine.
