[sonicgear1]

Wouldn't querying the count be slow using a WHERE clause?

[LesZedCB]

it was indexed which should help, but i assume that the reads are far less common than the inserts. reads could even be scheduled/automated and stored in a cache table if they need to be faster and ok being a little stale

[Andys]

There's only dozens (or at most ~100) rows.