⚡ Fixed ModelOptix admin page performance (3s → 300ms) with SQL function #modeloptix

#notepulse fix zero rows from sql bug

proceed redis migration for #crisp availability schedule system, since everyday at midnight our availability microservice started to crash cause it was trying to pull schedules for 600k users, something was definitely wrong here, so rebuilt everything from the SQL database, and now bug-busting

🍟 More SQL-ing. Managed to get a SQL command working to calculate word count of each post of an author, and update all posts under author with a word count tag. Soon - try it out in prod! #lifelog

🍟 Just manually updated the total word count of all posts for each of these users! @phaidenbauer @drodol @luke @poppacalypse @lifelog @cat @haideralmosawi - Thank god the SQL query works! #lifelog

refactor to reduce to SQL load #vietnamdevs

Reduce SQL queries on initial app load for #booklet

add maximum length for SQL input #linqmeup

back up sql for client and send zip .gz file #fajarsiddiq

Run sql query to remove sidebar from all product pages #chocolab

#contracting Optimize price querying function to use primary key so that the SQL queries go fast

- answer Billy abt the SQL query to show AOB related data for ASP tableau purposes ✅ #enpvqp

#trackfootball aggregate user stats for last month (current month was already visible), clean up SQL

filter outbound leads data from SQL, multiple tables #downpayment

copy SQL DB #consulting

Investigate why start page of client website is suddenly sending 7000+ SQL queries for a single request #contracting

tweaked sql conf

replace complicated burndown chart queries with one efficient SQL query #wip

backup SQL database

trace timings for all sql queries #wt