Re: MySQL ResultSet - count rows?
- From: Christoph <christoph.burschka@xxxxxxxxx>
- Date: Mon, 10 Dec 2007 03:47:40 -0800 (PST)
On Dec 10, 10:34 am, Dyreatn...@xxxxxxx wrote:
Christoph <christoph.bursc...@xxxxxxxxx> writes:
Hello,
I am writing the data of a ResultSet object to an array. To declare
the array length, I need to know the number of rows before copying
them - is there a way to read the row count instantly, without having
to iterate anything?
No. You could execute 'SELECT COUNT(*) ...' first but then you
essentially traverse all the rows twice.
(There could be non-standard MySQL extensions that lets you do this, I
don't know)
PHP has mysql_count_rows, but I'm not sure what that does internally -
it may just iterate over the data too.
--
dt
Questions about Derby/Java DB? Please visithttp://db.apache.org/derby/derby_mail.html
Okay, I'm working around it by using
while(result.next()) rowcount++;
At least incrementing the pointer is not a very expensive action. Even
when I get a few thousand results back (which I will) the counting
will take far less time than the copying and instance creation that
follows.
.
- References:
- MySQL ResultSet - count rows?
- From: Christoph
- Re: MySQL ResultSet - count rows?
- From: Dyreatnews
- MySQL ResultSet - count rows?
- Prev by Date: Re: MySQL ResultSet - count rows?
- Next by Date: Re: MySQL ResultSet - count rows?
- Previous by thread: Re: MySQL ResultSet - count rows?
- Next by thread: Re: MySQL ResultSet - count rows?
- Index(es):
Relevant Pages
|
