| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Carmen Wai" <wai_carmen(at)hotmail(dot)com> |
| Cc: | kleptog(at)svana(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Bulk row fetching |
| Date: | 2002-08-15 15:30:27 |
| Message-ID: | 23580.1029425427@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Carmen Wai" <wai_carmen(at)hotmail(dot)com> writes:
> I want to implement a similar mechanism as bulk row fetching in MFC ODBC
> classes for postgresql. For the very large record sets, it can fetch the
> first (let say) 100 records. After that, it can automatically fetch the next
> 100 records WITHOUT executing the SQL statement again, it will save lots of
> memory resouce / time.
> I only find that postgresql support : select * from table_name limit N
> offset M, but if I do it in this way, the DB need multiple execution which
> will take up lots of time.
Use a cursor.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2002-08-15 15:31:59 | Re: Problem with Now()? |
| Previous Message | Andrew Sullivan | 2002-08-15 15:29:40 | Re: Why choose PostreSQL and not MySQL or Oracle!! |