Skip to main content

Module triggered_inserts

Module triggered_inserts 

Source
Expand description

A workload of inserts that fire triggers, for measurements of what one triggered write costs.

Constants§

SCHEMA
Seven tables, a view over six of them, and three triggers on scans. The view placed joins each scan with its row in edits, verdicts, origins and skipped, and reads matches in two subqueries, to give the scan’s tab, state, title and top folder. After an insert or an update of a scan, a trigger writes the scan’s row of placed into listing; after a delete, a trigger deletes the scan’s row from listing. So each insert into scans reads the view once and writes listing once.