Re: [GENERAL] large query by offset and limt

2008-05-03 Thread Craig Ringer
Ge Cong wrote: Thank you very much. Could you show me how to do it in JDBC? Here's one example. As I haven't been using JDBC directly it's probably horrible, but it'll do the job. Any exception will terminate this example, but in practice you'd want to catch and handle exceptions appropriate

Re: [GENERAL] large query by offset and limt

2008-05-03 Thread Ge Cong
Thank you very much. Could you show me how to do it in JDBC? Craig Ringer wrote: > finecur wrote: > > Hi, I am ruuning a database behind a webserver and there is a table > > which is huge. I need to pull data from this table and send to user > > through http. If I use > > > > select * from huge_t

Re: [GENERAL] large query by offset and limt

2008-05-03 Thread Craig Ringer
finecur wrote: Hi, I am ruuning a database behind a webserver and there is a table which is huge. I need to pull data from this table and send to user through http. If I use select * from huge_table where userid = 100 It will return millions of records which exhuasts my server's memory. Is t

Re: [GENERAL] large query by offset and limt

2008-05-03 Thread Steve Atkins
On May 2, 2008, at 2:01 PM, finecur wrote: Hi, I am ruuning a database behind a webserver and there is a table which is huge. I need to pull data from this table and send to user through http. If I use select * from huge_table where userid = 100 It will return millions of records which exhuas

[GENERAL] large query by offset and limt

2008-05-03 Thread finecur
Hi, I am ruuning a database behind a webserver and there is a table which is huge. I need to pull data from this table and send to user through http. If I use select * from huge_table where userid = 100 It will return millions of records which exhuasts my server's memory. So I do this: select *