update analytics #fajarsiddiq

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

optimize db index #threadhunt

catchup with Levko about rebuilding queries #redash

analyze @lexfridman views #life

optimized check queries to reduce RDS load #zonewatcher

Compare analytics #jovial

Improving analytics for #talqui

Improving analytics for #talqui

backend optimization

improve db query response time #clippulse

add bullet gem to identify N+1 queries #wip

Update analytics tracking

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…

Reduce SQL queries on initial app load for #booklet

avoid N+1 queries by using includes #wip

improve analytics #buildpublic

Remove eager-loading of associated records (i.e. LEFT JOINS) because we now properly cache most things. Then those complex SQL queries are useless. #wip

updated sentry and start capturing more queries to debug where a specific query is coming from... #spectate

Replace activerecord callback with postgres triggers and functions when analyzing millions of #domains