Ask author of `neighbors` gem how to optimize my SQL queries, because I just realized that by adding vector embedding to the todos, we're now loading ~25x as much data whenever we're loading todos from the database even though in 99% of cases we don't need the embeddings #wip – github.com/ankane/neighbor/is…

Optimised sort by most popular query #preloved

#contracting Speed up database query that took 30s to only take 300ms because I finally figured out that I had a textbook fulltext search problem. Oops.

improve performance of month over month report by 10x #reva

Optimized database queries #visulry

#spotgetter 🤷 faster search speed

Simplify and speed up almost every single database query by moving the visibility filtering logic (hide expired posts, hide all posts from hidden companies, etc) into a cached boolean column (`active`) that's updated hourly #startupjobs

Speed up #wip search by adding proper index, which was missing because in 2022 I changed the way search works and it no longer used the old index /cc @levelsio

#trackfootball aggregate user stats for last month (current month was already visible), clean up SQL

Various improvements in perf and code quality on blocks fetch page #inpilot

Improve performance #uberaddress

Tweak search query design for #builderbelt

page speed improvements #goldenhour

See response times drop significantly after switching to permanent avatar URLs and fixing indexes for todo similarity search #wip

improved query for remote jobs #sportstechjobs

add SQL index on hash in filters.db to speed up writing after filtering #nomads

fix slow query #rewardsflights

improve /discover pages performance by A LOT (if not searching countries/continents) #beachnearby