Simple Killer Queries

Simple Killer Queries

Recently we ran into an example of a ‘simple’ query that was doing an immense amount of work. There were a number of reasons behind this, but perhaps the most telling part was the difference between the EXPLAIN (which we routinely run on all system...
PL/R function example – outbreak detection methods

PL/R function example – outbreak detection methods

Dynamic Cluster Detection using pl/r functions The ability to detect clusters of outbreaks as soon as possible was investigated. Cluster detection methods were coded as procedural language functions in the database and made available through a web interface. Methods...