Foxhound Systems

Everyone who writes SQL occasionally encounters poorly performing queries. SQL's UNION operation isn't typically employed for performance optimization, but it can be used to both simplify and radically improve query speed.

Speeding up SQL queries by orders of magnitude using UNION – Foxhound Systems 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.

We've just published a new blog post: Using the strengths of Haskell's type system to improve the process of grouping SQL query results.

Reducing the pain of grouping SQL query results using Haskell – Foxhound Systems 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.