Back
Similar todos
Load previous page…
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 #wipgithub.com/ankane/neighbor/is…
See similar todos
Optimised sort by most popular query #preloved
See similar todos

No replies yet

#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.
See similar todos

No replies yet

improve performance of month over month report by 10x #reva
See similar todos

No replies yet

Optimized database queries #visulry
See similar todos

No replies yet

#spotgetter 🤷 faster search speed
See similar todos

No replies yet

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
See similar todos

No replies yet

Optimized a database query to reduce the load on the main production #screenshotone database.
See similar todos

No replies yet

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
See similar todos

No replies yet

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

No replies yet

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

No replies yet

Improve performance #uberaddress
See similar todos

No replies yet

Tweak search query design for #builderbelt
See similar todos

No replies yet

page speed improvements #goldenhour
See similar todos

No replies yet

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

No replies yet

improved query for remote jobs #sportstechjobs
See similar todos

No replies yet

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

No replies yet

fix slow query #rewardsflights
See similar todos

No replies yet