How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Query latency when fetching and updating records from a moderately sized table (~15k–50k rows)

calendar_today November 12, 2026 person @jahanzeb.khn07 Jahanzeb Khan domain bubbles

Your biggest problem is that your search runs on 15k entries and then extracts 50 questions, what I will recommend is to break them down into categories and sub categories When extracting for users, you run the random search on you category levels, e.g. 15000 entires → 15 categories → 10 subcategories each → assume 300 questions each when user interacts, you extracte a random category, then select a sub category and then search for questions in that subcategory You will need to loop this to run a few times to extarct 50 questions, but that should solve your initial problem

open_in_new Read original post