Demo, all content is generated
Review request

Flashcard app for my class, 200 students start Monday, will it hold?

Open · 97 views · asked by rosa_m · edited

Repo or live app

github.com/rosa-martin/flashdeck

Unsure about: PerformanceCosts

Right now 12 students use it and everything is instant. On Monday two full year groups get the link, so roughly 200 people in the same 50 minutes. Cursor built it on Supabase with a cards table and a reviews table that gets a row per answer. I have no idea whether that is a normal load or a lot.

Comment
200 students in 50 minutes is small for Postgres. What I'd check is an index on reviews(user_id), and whether each card view fetches the whole deck. hannah_reyes · edited
Each card view fetches the whole deck, 400 cards. Is that bad? rosa_m · edited
Not at 400 cards, but fetch it once per session, not per card. That's 200x fewer requests on Monday. hannah_reyes · edited

Activity

20 helpers notified