in reply to Empty Set
Empty table == no rows. Therefore: my $query = "SELECT count(*) FROM users";Some databases will store the count in the catalog (Informix used to) and will return very quickly. Some will count quickly if you have a clustered index on the table. Some will just count every row....
HTH
|
|---|