title: What is the most efficient way to count rows in a table in SQLite?
body: <p>I've always just used "SELECT COUNT(1) FROM X" but perhaps this is not the most efficient.  Any thoughts?  Other options include SELECT COUNT(*) or perhaps getting the last inserted id if it is auto-incremented (and never deleted).</p>
  
  <p>How about if I just want to know if there is anything in the table at all?  (e.g., count > 0?)</p>