seed.sql

-- Seed a big table for exercising the tracer's row-count + timing output.
-- Usage: sqlite3 /tmp/t.db < seed.sql
-- Override the row count: sqlite3 /tmp/t.db --cmd ".param set :n 1000000" < seed.sql
-- (defaults to 500000 if :n is unset)

PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

DROP TABLE IF EXISTS big;
CREATE TABLE big (
	id    INTEGER PRIMARY KEY,
	k     INTEGER NOT NULL,
	g     INTEGER NOT NULL,
	label TEXT    NOT NULL,
	val   REAL    NOT NULL
);

INSERT INTO big (id, k, g, label, val)
SELECT
	value,
	abs(random() % 1000000),
	value % 100,
	'row-' || value,
	(random() % 1000000) / 1000.0
FROM generate_series(1, coalesce(:n, 500000));

CREATE INDEX idx_big_k ON big(k);
CREATE INDEX idx_big_g ON big(g);

ANALYZE;

SELECT count(*) AS rows_seeded, count(DISTINCT g) AS groups FROM big;