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
