Note that a few indexes that are required to prevent table scans are not present in the schema; these were added later and I don't have a database migration script just yet, so it's expected that these queries will run a bit slow unless you've manually created the needed indexes.
I just took a few minutes to knuckle-down and
get this done. I recommend that all users get the latest from master and apply the DB migration script. Dashboard performance should significantly improve (to sub-second response times).