#sqlapi

PrecisionSQLPrecisionSQL
2026-02-05

What's wrong with this SQL COUNT?

What's wrong with this SQL COUNT in an API. The SQL code uses COUNT(*) on a huge table for every request, causing slow queries and CPU spikes. In SQL services this creates latency incidents.

youtube.com/watch?v=foeqcPCOghw

Client Info

Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst