We've increased our performance by decreasing the number of queries

Under the hood, Oh Dear is a large Laravel application that performs many queries all of the time. To power future features, we've recently changed our database structure and refactored some pieces in our code base. We increased performance by decreasing the number of queries.

As an Oh Dear user, you've probably not noticed any changes. Our UI has always been very responsive. Most of the changes impacted the work that we perform on a queue, which is where 99% of our workload happens.

To learn more about the specific changes we made, check out this extensive blog published on freek.dev. If you're a PHP or Laravel developer, you could leverage some of our techniques in your projects.