Facebook Twitter GitHub LinkedIn LinkedIn LinkedIn
Back to all posts

Posts tagged: performance-optimization

October 7, 2022

Server side caching

Essential elements of high performance applications
By Christian Charukiewicz
Server side caching can be used to cut down the time required to return the results of expensive queries by orders of magnitude.
July 25, 2022

Offloading work to the SQL database

Essential elements of high performance applications
By Christian Charukiewicz and Ben Levy
Offloading work from the application server to the database through the effective use of advanced SQL features can greatly improve application performance.
May 24, 2022

SQL indexes

Essential elements of high performance applications
By Christian Charukiewicz
Effectively using SQL indexes is a huge boon to performance of a web application.
March 19, 2021

Speeding up SQL queries by orders of magnitude using UNION

By Ben Levy and Christian Charukiewicz
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.
November 23, 2020

Reducing the pain of grouping SQL query results using Haskell

By Ben Levy and Christian Charukiewicz
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.