From: | Marc Howard Zuckman <marc(at)fallon(dot)classyad(dot)com> |
---|---|
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: | [HACKERS] Alternative to LIMIT in SELECT ? |
Date: | 1998-10-13 23:27:04 |
Message-ID: | Pine.LNX.4.02A.9810131905180.4176-100000@fallon.classyad.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
I can't speak to the relative efficiencies of the methods, but I do
perform queries that present data subsets to web browsers using postgresql
with the following method:
1) collect data input; do cgi query; write tuples to temporary file
2) html page index sent back to browser contains page specific
references to temporary file name and tuple range.
3) Subsequent data retrievals reference temporary file using sed and
tuple range
4) temporary file is destroyed 15min after last access time by a
background process.
This consumes disk space, but I assume it conserves memory compared to
a cursor/fetch sequence performed in a persistent db connection.
For a general purpose query, I'm not sure if there is any other
alternative to this method unless you wish to reperform the query
for each retrieved html page.
Marc Zuckman
marc(at)fallon(dot)classyad(dot)com
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_ Visit The Home and Condo MarketPlace _
_ http://www.ClassyAd.com _
_ _
_ FREE basic property listings/advertisements and searches. _
_ _
_ Try our premium, yet inexpensive services for a real _
_ selling or buying edge! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-10-14 00:47:01 | Re: [HACKERS] What about LIMIT in SELECT ? |
Previous Message | Eric Lee Green | 1998-10-13 23:17:20 | Re: [HACKERS] What about LIMIT in SELECT ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Orlandi | 1998-10-13 23:33:01 | Re: [ADMIN] COPY slows down; is it normal? |
Previous Message | Eric Lee Green | 1998-10-13 23:17:20 | Re: [HACKERS] What about LIMIT in SELECT ? |