Back
Similar todos
Added an index to our main db lowering the query time on a popular query from 700ms to 45ms on average
optimize postgres query add index, reduce time of run from 10 sec to less than 1 
#capgo
try to fix index for too long query #capgo
process queries 2.5x more faster 
#nanobrain
fix slow query 
#rewardsflights
fix queries for huge performance boost 
#spectate
trace timings for all sql queries 
#wt
Improved query performance of "unread" section by ~ 5 times. 
#gistreader
improve db query response time 
#clippulse
see performance improvements to query latencies due to tweaks #spectate
speed up 
#interiorai load with DB index
find 
#photoai bottleneck thanks to @daniellockyer with NewRelic and it was the average photo waiting time calculator SQL query that took 18 seconds and ran hourly and would take down the site
