Review request

Birdwatching log with 40k sightings, the map page takes nine seconds

Open · 12 views · asked by ines_data · edited

Repo or live app

github.com/inesferreira/birdlog

Unsure about: Performance

Personal project that got out of hand: 40k rows in sightings, each with a species, a point and a date. The map fetches everything in the current bounding box and draws markers. Query is where lat between ? and ? and lng between ? and ?. No indexes beyond the primary key. Nine seconds on the first load, faster after.

Comment

Activity

7 helpers notified