optimize db index #threadhunt

optimized check queries to reduce RDS load #zonewatcher

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

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

workflow optimization #webscape

optimize postgres query add index, reduce time of run from 10 sec to less than 1 #capgo

Optimize API queries with live data tables #scouvy

track every possible event I could think of with analytics

#newsbetters setup analytics

setup analytics #wobaka

sketch out analytics database schema #rekonise

try to figure out nested queries in supabase