pub const LOOKUP_STEPS: i32 = 1_000;Expand description
The most SQLite steps one question about a changed row runs. A lookup no index serves reads its partner row by row; past this it stops and the query runs again, so a write’s cost stays bounded whatever the app’s indexes.