hi jack, search the list on count query.
-----Ursprüngliche Nachricht----- Von: Jack O'Connor [mailto:[EMAIL PROTECTED] Gesendet: Montag, 23. Juli 2007 12:50 An: [email protected] Betreff: 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
