Re: Limiting the number of records in Execute Query - Mailing list pgsql-odbc

Raj Shooj-Q16466 <shooj@motorola.com> writes:
> I am retrieving 1 million records by executing the sql query
>    SELECT * FROM myTable ORDER BY sub_id LIMIT 20000 OFFSET <num>;
> in a loop, incrementing <num> every time by 20000.

Wouldn't it be better to use a cursor?

    BEGIN;
    DECLARE c CURSOR FOR SELECT * FROM myTable ORDER BY sub_id;
    FETCH 20000 FROM c;
    ... repeat FETCH as needed ...
    COMMIT;

            regards, tom lane