mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
12 lines
271 B
Plaintext
12 lines
271 B
Plaintext
|
|
PRAGMA page_size = 1024;
|
|
CREATE TABLE t1(a, b);
|
|
BEGIN;
|
|
WITH data(x,y) AS ( SELECT 1, zeroblob(10000) UNION ALL SELECT x+1, y FROM data WHERE x < 30000) INSERT INTO t1 SELECT * FROM data;
|
|
COMMIT;
|
|
|
|
|
|
PRAGMA cache_size = 4194304;
|
|
CREATE INDEX i1 ON t1(a, b);
|
|
|