Re: [HACKERS] What about LIMIT in SELECT ? - Mailing list pgsql-hackers

From Matthew N. Dodd
Subject Re: [HACKERS] What about LIMIT in SELECT ?
Date
Msg-id Pine.BSF.4.02.9810140229360.17054-100000@sasami.jurai.net
Whole thread Raw
In response to Re: [HACKERS] What about LIMIT in SELECT ?  (Eric Lee Green <eric@linux-hw.com>)
List pgsql-hackers
On Tue, 13 Oct 1998, Eric Lee Green wrote:
> it's really hard to test, unfortunately, due to the differing natures
> of MySQL and PostgreSQL. MySQL starts up a connection very fast while
> PostgreSQL takes awhile (has anybody done work on the "herd of
> servers"  concept to tackle that?).

Is MySQL really all that much faster?  I've got a large number of CLI
utilities that pull data from a DB on a central server and I'm lagging on
scroll speed in my xterms for the most part.  I've yet to see any
measureable lag in connection setup.

My hardware isn't all that fast either.  (Ultra5 client, Ultra1/170E
server.)

--
| Matthew N. Dodd  | 78 280Z | 75 164E | 84 245DL | FreeBSD/NetBSD/Sprite/VMS |
| winter@jurai.net |      This Space For Rent     | ix86,sparc,m68k,pmax,vax  |
| http://www.jurai.net/~winter | Are you k-rad elite enough for my webpage?   |


pgsql-hackers by date:

Previous
From: "Matthew N. Dodd"
Date:
Subject: Re: [HACKERS] What about LIMIT in SELECT ?
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: inet/cidr/bind