Back
Similar todos
Load previous page…
Refactor 
#bondwise to use Snowflake-IDS and optimise some long-taking queries
Apply optimisations to client website 
#freelance
finally commit lots of data fetching improvements 
#checkoutpage
see performance improvements to query latencies due to tweaks 
#spectate
Improve DB performance
optimze mysql index
optimise performance from 18% to 90+ 
#freelancegig
fixed some queries on 
#devopsprojectshq so that they work better for my users
wp-optimize 
#ryce
Optimized DB 
#ismovielikebook
Optimize query to only have 1 lookup instead of 2 
#plumberjobs
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
tweet about optimization work for client 
#freelance
set some new SQLite config optimizations form phiresky.github.io/blog/2020/… to fix incidental error 
#hoodmaps
fix n+1 query on events page 
#june
write a ridiculous amount of queries 
#life
find heavy SQL processes with NewRelic thx to @daniellockyer to fix #photoai 502 errors and move it to 2 scheduled worker processes /workers/generateLandingPageSamplePhotosCache.php and /workers/generateSamplePromptsCache.php so it doesn’t break the site when cache stale
