Re: MySQL ResultSet - count rows?

Christoph wrote:

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?

PHP has mysql_count_rows, but I'm not sure what that does internally -
it may just iterate over the data too.


There is a SQL statement to the effect: select count(*) from tablename
Look it up to see if it can be optimized.
--
Sabine Dinis Blochberger

Op3racional
www.op3racional.eu
.

Relevant Pages

  • Re: [ANN] Rio 0.3.4
    ... > Will a modification of IRB with RIO, and a few other things, possibly result ... >> Ways to get the chomped lines of a file into an array ... >> Iterate over only the files in a directory ... >> * New Grande Selection parameter. ...
    (comp.lang.ruby)
  • [ANN] Rio 0.3.4
    ... Rio is a Ruby I/O convenience class wrapping much of the functionality ... Copy or append a file to a string ... Ways to get the chomped lines of a file into an array ... Iterate over only the files in a directory ...
    (comp.lang.ruby)
  • [ANN] Rio 0.3.7
    ... Rio is a Ruby I/O convenience class wrapping much of the functionality ... Copy or append a file to a string ... Ways to get the chomped lines of a file into an array ... Iterate over only the files in a directory ...
    (comp.lang.ruby)
  • [ANN] Rio 0.4.1
    ... = Rio - Ruby I/O Facilitator ... Iterate over the .rb files in a directory and its subdirectories. ... Return an array of the .rb files in a directory and its ... Copy or append a file to a string ...
    (comp.lang.ruby)
  • {ANN] Rio 0.4.0
    ... = Rio - Ruby I/O Facilitator ... Iterate over the .rb files in a directory and its subdirectories. ... Return an array of the .rb files in a directory and its ... Copy or append a file to a string ...
    (comp.lang.ruby)