Summary

Browse is SELECT * FROM db.t LIMIT n OFFSET m with no ORDER BY — InnoDB pages skip/duplicate without a PK order. COUNT(*) on large InnoDB tables is a full scan and shares the pooled socket (30s-style timeouts via forceClose).

Scope

• When a PK exists, ORDER BY those columns.
• Do not require blocking COUNT(*) before first paint (estimate TABLE_ROWS from information_schema.TABLES or count asynchronously).
• Timeout must not kill the SQL-editor socket if they still share a pool key (see shared-socket issue).

Out of scope

• Changing default page size (200).
• Postgres fix(postgres): browse on read-only; page with ORDER BY PK; do not block on COUNT(*) #788 / SQLite fix(sqlite): page Table Browser with ORDER BY PK/rowid; do not block on COUNT(*) #799.