| From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Bill Thoen" <bthoen(at)gisnet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks |
| Date: | 2008-06-27 21:01:14 |
| Message-ID: | 396486430806271401h6001a82cl81d5ef4a1ddb60e4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jun 27, 2008 at 2:09 PM, Bill Thoen <bthoen(at)gisnet(dot)com> wrote:
> Thanks for tip on OFFSET. That's just what I needed. It's so easy when you
> know the command you're looking for, and so hard when you know what you want
> to do but don't know what the command is called!
I would strongly suggest taking a second look at Ragnar's suggestion.
It may be a bit more difficult to implement, but I is a clear
performance winner when you start to deal with large datasets and the
OFFSET get really big.
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Thoen | 2008-06-27 21:09:29 | Re: Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks |
| Previous Message | Olexandr Melnyk | 2008-06-27 20:29:03 | Re: Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks |