http://qs1969.pair.com?node_id=1102717


in reply to Count in intervals

10M rows in sqlite isn't that large. Have you declared indexes?