#untalent Optimize queries to the database

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

make #nomads search super fast

wish I got more than 10min at a time to read this sql is forever paper #blog2

Improve DB performance

fix slow query #rewardsflights

Enable full-text search for #superx

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

Finally feed the 2 million products to database and now the search index page is damn slow #dill

see performance improvements to query latencies due to tweaks #spectate

try to fix index for too long query #capgo

added fuzzysearch to find names blazing fast #names

/done speed up pages and search by indexing better

rewrite first 1500 words of database chapter #serverlesshandbook

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…

optimize a ~380ms request to 17ms - twitter.com/DanielLockyer/sta… #nomads

Found why I was spamming for nothing, my DB of writes #capgo

Fix an issue with the exact word match searching code causing infinite loops in some cases #positify