mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
ad79ef48a2
* add tests * add bench
21 lines
854 B
Plaintext
21 lines
854 B
Plaintext
|
|
PRAGMA page_size = 512;
|
|
PRAGMA auto_vacuum = 2;
|
|
CREATE TABLE t1(x);
|
|
INSERT INTO t1 VALUES(randomblob(400));
|
|
INSERT INTO t1 SELECT * FROM t1; -- 2
|
|
INSERT INTO t1 SELECT * FROM t1; -- 4
|
|
INSERT INTO t1 SELECT * FROM t1; -- 8
|
|
INSERT INTO t1 SELECT * FROM t1; -- 16
|
|
INSERT INTO t1 SELECT * FROM t1; -- 32
|
|
INSERT INTO t1 SELECT * FROM t1; -- 128
|
|
INSERT INTO t1 SELECT * FROM t1; -- 256
|
|
INSERT INTO t1 SELECT * FROM t1; -- 512
|
|
INSERT INTO t1 SELECT * FROM t1; -- 1024
|
|
INSERT INTO t1 SELECT * FROM t1; -- 2048
|
|
INSERT INTO t1 SELECT * FROM t1; -- 4096
|
|
INSERT INTO t1 SELECT * FROM t1; -- 8192
|
|
DELETE FROM t1 WHERE oid>512;
|
|
DELETE FROM t1;
|
|
|