process queries 2.5x more faster #nanobrain

see performance improvements to query latencies due to tweaks #spectate

merged in some homepage query count speedups #djangopackages

fix queries for huge performance boost #spectate

improve db query response time #clippulse

make changes to data structure and queries and see 6x speed improvement on status pages without caching #spectate

speed up some queries #indie

Improve "related posts" query (more relevant and faster) #startupjobs

#nagel Find SQL query that has no indexes and ran for >5 seconds, so add index and now it runs in 0.01s

Added an index to our main db lowering the query time on a popular query from 700ms to 45ms on average

improve performance by 10x of average rating per channel query #reva

Improved performance by 2270 ms #remote3

remove filter queries/slugs <30d ago from filters.db because there were like 500,000+ and maybe better to have less (now 50,000) #nomads

find out about a query causing high load - disabling the feature drastically improves performance #spectate

get page load #remoteok down to 50ms with my new query caching engine

🚀 shipped a new #djangopackages update that drops at least ~4 db queries off of one our pages taht gets accessed >1 million times a month

add indexes to users.db to speed up #remoteok workers page load time from 5 seconds to less

continue streak of improving some queries or even get rid of them entirely 🚀 #spectate

mongo #skrrt up - filters load 3x faster

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…