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 viewplacedjoins each scan with its row inedits,verdicts,originsandskipped, and readsmatchesin 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 ofplacedintolisting; after a delete, a trigger deletes the scan’s row fromlisting. So each insert intoscansreads the view once and writeslistingonce.