Convoluted sql to get athlete name for activity details - Githubissues

BigPugLabs / ridevis

Ride Visualisation

https://ridevis.vercel.app

0 stars 0 forks source link

Convoluted sql to get athlete name for activity details #9

Open BigPugLabs opened 7 months ago

BigPugLabs commented 7 months ago

The following query is a bit convoluted https://github.com/BigPugLabs/ridevis/blob/main/app/activity/%5Bid%5D/page.tsx#L9-L13

consider prepared statement and/or revise schemas to avoid triple join just to get the athlete name https://orm.drizzle.team/docs/perf-queries

Options

store Athlete name on activities
store on users
pull from session on demand, it's probably the logged in users activity