---
title: "sql - SQLite: COUNT slow on big tables - Stack Overflow"
description: "!https://stackoverflow.com/questions/8988915/sqlite-count-slow-on-big-tables"
date: 2024-04-01
published: true
tags:
  - database
  - sql
  - sqlite
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://stackoverflow.com/questions/8988915/sqlite-count-slow-on-big-tables" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-content">
      <div class="embed-card-title">External Link</div>
      <div class="embed-card-meta">stackoverflow.com</div>
    </div>
  </a>
</div>


Another interesting option for slow count queries in sqlite.

> If you haven't DELETEd any records, doing:

``` sql
SELECT MAX(ROWID) FROM "table" LIMIT 1;
```