counting rows

From: Jack O'Connor (jo418..ristol.ac.uk)
Date: Mon Jul 23 2007 - 06:49:56 EDT

  • Next message: Peter Schröder: "AW: counting rows"

    A question about efficiency: Counting the number of rows in a table.

    Currently, I run a select query, then iterate through the rows,
    incrementing a counter. This takes too long. Is there a way to use the
    SQL command:
    SELECT count(*) FROM <table>

    Or something similar, that quickly returns the number of rows from a
    select query?

    Thanks
    Jack

    This archive was generated by hypermail 2.0.0 : Mon Jul 23 2007 - 06:50:57 EDT