#nagel Bring down uncached 22s response down to uncached 700ms response

#nagel Pre-generate category trees on production for 11,000 sellable parts

#nagel Find SQL query that has no indexes and ran for >5 seconds, so add index and now it runs in 0.01s

#nagel Cache part categorization tree because so far we've been building it on demand and it's a nested recursive tree, so if you request 700 parts suddenly the request takes 22s and the frontend team is sad

#nagel Rip out Pimcore ORM in another part of the app and replace with raw SQL, as ORM creates insane amounts of overhead

#life Make sure everyone gets to their appointment on time

#nagel Mark parts that do not have a special price based on their age

#nagel Add button to globally re-import settlement rates outside of daily sync in case a service worker updates rates in ERP

#life Send update to pug breeder for puggy's first birthday

#life Eat Christmas ham 🇵🇭

#life Get new debit card

#life Tell accountant that he's unfired and re-hired because life is weird

#life Accounting Q4 '21

#life Switch from farmer bank to better bank

#life Season cast-iron pan

#life Sum up earnings for last year of business

#nagel Get confirmation for contract with all of my desired benefits

#nagel Prepare move away from managed hosting to cheaper/better/I get more control VPS

#nagel Check that Pimcore is still running

#nagel Unfuck dependency tree and update everything for PHP 8.1