Posts tagged: performance-optimization

Server side caching can be used to cut down the time required to return the results of expensive queries by orders of magnitude.

Offloading work from the application server to the database through the effective use of advanced SQL features can greatly improve application performance.

Effectively using SQL indexes is a huge boon to performance of a web application.

SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.

Semigroups allow us to transform the denormalized results of our SQL queries into a structure that models parent-child relationships by focusing on the types we want to achieve rather than by writing tedious merge operations.