eksopl/fuuka — Issue #14: Make some of the reports update in real time
Author: eksopl
Created: 2012-02-21 15:36:29+00:00
State: open
Labels: Feature, Reports

Some of the reports run prohibitively expensive SQL queries. This can and should be mitigated by having triggers and auxiliary tables that track said data on the fly.

Supporting better DB engines in the future will also depends on this, since `count(*)`s tend to be very expensive in good DBs. InnoDB on MySQL and PostgreSQL behave that way, for example.