in reply to SQLite: how to get a number of rows from SELECT query

If all that you need is the count, then something like this should work much more efficiently: select count(*) as count from ...
  • Comment on Re: SQLite: how to get a number of rows from SELECT query