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_table where userid = 100 > > > > It will return millions of records which exhuasts my server's memory. > > > Is there a better way to do this? > > Consider using database cursors. Set up by beginning a transaction and > issuing the statement: > > DECLARE huge_table_curs CURSOR FOR > SELECT * FROM huge_table WHERE userid = 100; > > ... then to get results, just execute: > > FETCH 1000 FROM huge_table_curs; > > -- > Craig Ringer > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
