Обсуждение: Obtaining nTuples from a cursor

Поиск
Список
Период
Сортировка

Obtaining nTuples from a cursor

От
Michael Dunn
Дата:
I would like to know if there is a way to return nTuples for a cursor
without having to FETCH ALL from the cursor.  I am sorting over 500k
records and growing.. and return 1k at time from the cursor.  But, It
would be nice to obtain the number of records in the cursor with having
to either do a SELECT count(*) of the same query or returning ALL from
the cursor.  It is entirely innefficient...

Regards, Michael