Re: [HACKERS] What about LIMIT in SELECT ?

From: "Matthew N(dot) Dodd" <winter(at)jurai(dot)net>
To: Eric Lee Green <eric(at)linux-hw(dot)com>
Cc: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, Jeff Hoffmann <jeff(at)remapcorp(dot)com>, PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] What about LIMIT in SELECT ?
Date: 1998-10-14 06:32:30
Message-ID: Pine.BSF.4.02.9810140229360.17054-100000@sasami.jurai.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs 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(at)jurai(dot)net | This Space For Rent | ix86,sparc,m68k,pmax,vax |
| http://www.jurai.net/~winter | Are you k-rad elite enough for my webpage? |

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Jan Wieck 1998-10-14 11:09:21 Re: [HACKERS] What about LIMIT in SELECT ?
Previous Message Matthew N. Dodd 1998-10-14 06:25:31 Re: [HACKERS] What about LIMIT in SELECT ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-10-14 06:42:57 Re: [HACKERS] Re: inet/cidr/bind
Previous Message Matthew N. Dodd 1998-10-14 06:25:31 Re: [HACKERS] What about LIMIT in SELECT ?