RE : Nmber of rows in a ResultSet

Поиск
Список
Период
Сортировка
От Xavier Bugaud
Тема RE : Nmber of rows in a ResultSet
Дата
Msg-id 94BCF3512BFBD711B79D004005420B1F03F6D8@PMSERVER
обсуждение исходный текст
Ответы Re: RE : Nmber of rows in a ResultSet  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
> On Fri, 9 Jan 2004, Kris Jurka wrote:
>
> > In the last JDBC drivers, is there a means to get the number of rows
> > directly (without using 'SELECT COUNT(*)' or
> 'rs.last();rs.getrow();') ?
>
> I don't see what's so wrong with rs.last() and rs.getRow().
>

Thank you for the response.

What is wrong with rs.last() and rs.getRow() is
- it requires scrollable cursors in order to get back to the first row
- it will certainly slow down the operation in case of huge amount of
rows (I don't known how the Postgres driver handle that, so maybe this
is wrong... I hope so)



Regards
--
Xavier Bugaud
www.gloptv.com


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: [BUGS] JDBC driver doesn't handle NaN values
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: [BUG] - Invalid UNICODE character sequence found