#nagel Have my Confluence account fixed after 1.5 years of it being broken

#nagel Update daily stock sync robot to use primary key for update query, because it's much more efficient

#nagel Make sure that daily stock sync robot also accounts for IAM parts which have a secondary, proper partnumber that differs from the OEM number

#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

#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

#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