Lines Matching refs:speedtest1_exec
412 void speedtest1_exec(const char*,...);
417 if( g.doCheckpoint ) speedtest1_exec("PRAGMA wal_checkpoint;"); in speedtest1_end_test()
484 void speedtest1_exec(const char *zFormat, ...){ in speedtest1_exec() function
742 speedtest1_exec("BEGIN"); in testset_main()
743 speedtest1_exec("CREATE%s TABLE z1(a INTEGER %s, b INTEGER %s, c TEXT %s);", in testset_main()
754 speedtest1_exec("COMMIT"); in testset_main()
760 speedtest1_exec("BEGIN"); in testset_main()
761 speedtest1_exec( in testset_main()
773 speedtest1_exec("COMMIT"); in testset_main()
779 speedtest1_exec("BEGIN"); in testset_main()
780 speedtest1_exec( in testset_main()
792 speedtest1_exec("COMMIT"); in testset_main()
802 speedtest1_exec("BEGIN"); in testset_main()
816 speedtest1_exec("COMMIT"); in testset_main()
822 speedtest1_exec("BEGIN"); in testset_main()
838 speedtest1_exec("COMMIT"); in testset_main()
844 speedtest1_exec("BEGIN"); in testset_main()
860 speedtest1_exec("COMMIT"); in testset_main()
865 speedtest1_exec("BEGIN"); in testset_main()
881 speedtest1_exec("COMMIT"); in testset_main()
886 speedtest1_exec("BEGIN;"); in testset_main()
887 speedtest1_exec("CREATE UNIQUE INDEX t1b ON z1(b);"); in testset_main()
888 speedtest1_exec("CREATE INDEX t1c ON z1(c);"); in testset_main()
889 speedtest1_exec("CREATE UNIQUE INDEX t2b ON z2(b);"); in testset_main()
890 speedtest1_exec("CREATE INDEX t2c ON z2(c DESC);"); in testset_main()
891 speedtest1_exec("CREATE INDEX t3bc ON t3(b,c);"); in testset_main()
892 speedtest1_exec("COMMIT;"); in testset_main()
898 speedtest1_exec("BEGIN"); in testset_main()
912 speedtest1_exec("COMMIT"); in testset_main()
918 speedtest1_exec("BEGIN"); in testset_main()
932 speedtest1_exec("COMMIT"); in testset_main()
938 speedtest1_exec("BEGIN"); in testset_main()
951 speedtest1_exec("COMMIT"); in testset_main()
956 speedtest1_exec("BEGIN"); in testset_main()
957 speedtest1_exec( in testset_main()
964 speedtest1_exec("CREATE INDEX t4b ON t4(b)"); in testset_main()
965 speedtest1_exec("CREATE INDEX t4c ON t4(c)"); in testset_main()
966 speedtest1_exec("INSERT INTO t4 SELECT * FROM z1"); in testset_main()
967 speedtest1_exec("COMMIT"); in testset_main()
972 speedtest1_exec("DELETE FROM z2;"); in testset_main()
973 speedtest1_exec("INSERT INTO z2 SELECT * FROM z1;"); in testset_main()
978 speedtest1_exec("VACUUM"); in testset_main()
983 speedtest1_exec("ALTER TABLE z2 ADD COLUMN d INT DEFAULT 123"); in testset_main()
984 speedtest1_exec("SELECT sum(d) FROM z2"); in testset_main()
990 speedtest1_exec("BEGIN"); in testset_main()
1001 speedtest1_exec("COMMIT"); in testset_main()
1007 speedtest1_exec("BEGIN"); in testset_main()
1016 speedtest1_exec("COMMIT"); in testset_main()
1020 speedtest1_exec("UPDATE z2 SET d=b*4"); in testset_main()
1025 speedtest1_exec("SELECT sum(d) FROM z2"); in testset_main()
1032 speedtest1_exec("BEGIN"); in testset_main()
1043 speedtest1_exec("COMMIT"); in testset_main()
1049 speedtest1_exec("BEGIN"); in testset_main()
1058 speedtest1_exec("COMMIT"); in testset_main()
1063 speedtest1_exec("REPLACE INTO z2(a,b,c) SELECT a,b,c FROM z1"); in testset_main()
1064 speedtest1_exec("REPLACE INTO t3(a,b,c) SELECT a,b,c FROM z1"); in testset_main()
1068 speedtest1_exec("DELETE FROM z2;"); in testset_main()
1069 speedtest1_exec("INSERT INTO z2(a,b,c)\n" in testset_main()
1071 speedtest1_exec("INSERT INTO z2(a,b,c)\n" in testset_main()
1078 speedtest1_exec("BEGIN"); in testset_main()
1093 speedtest1_exec("COMMIT"); in testset_main()
1110 speedtest1_exec("BEGIN"); in testset_main()
1111 speedtest1_exec("CREATE%s TABLE t5(a INTEGER PRIMARY KEY, b %s);", in testset_main()
1121 speedtest1_exec("COMMIT"); in testset_main()
1131 speedtest1_exec("BEGIN"); in testset_main()
1140 speedtest1_exec("COMMIT"); in testset_main()
1148 speedtest1_exec("BEGIN"); in testset_main()
1149 speedtest1_exec("CREATE%s TABLE t6(a TEXT PRIMARY KEY, b %s)%s;", in testset_main()
1160 speedtest1_exec("COMMIT"); in testset_main()
1165 speedtest1_exec("BEGIN"); in testset_main()
1175 speedtest1_exec("COMMIT"); in testset_main()
1179 speedtest1_exec("SELECT DISTINCT b FROM t5;"); in testset_main()
1180 speedtest1_exec("SELECT DISTINCT b FROM t6;"); in testset_main()
1185 speedtest1_exec("PRAGMA integrity_check"); in testset_main()
1190 speedtest1_exec("ANALYZE"); in testset_main()
1372 speedtest1_exec("BEGIN"); in testset_fp()
1373 speedtest1_exec("CREATE%s TABLE z1(a REAL %s, b REAL %s);", in testset_fp()
1383 speedtest1_exec("COMMIT"); in testset_fp()
1399 speedtest1_exec("BEGIN;"); in testset_fp()
1400 speedtest1_exec("CREATE INDEX t1a ON z1(a);"); in testset_fp()
1401 speedtest1_exec("CREATE INDEX t1b ON z1(b);"); in testset_fp()
1402 speedtest1_exec("CREATE INDEX t1ab ON z1(a,b);"); in testset_fp()
1403 speedtest1_exec("COMMIT;"); in testset_fp()
1420 speedtest1_exec("SELECT sum(round(a,2)+round(b,4)) FROM z1;"); in testset_fp()
1425 speedtest1_exec( in testset_fp()
1492 speedtest1_exec("BEGIN"); in testset_rtree()
1493 speedtest1_exec("CREATE VIRTUAL TABLE rt1 USING rtree(id,x0,x1,y0,y1,z0,z1)"); in testset_rtree()
1509 speedtest1_exec("COMMIT"); in testset_rtree()
1513 speedtest1_exec("CREATE TABLE z1(id INTEGER PRIMARY KEY,x0,x1,y0,y1,z0,z1)"); in testset_rtree()
1514 speedtest1_exec("INSERT INTO z1 SELECT * FROM rt1"); in testset_rtree()
1657 speedtest1_exec("INSERT OR IGNORE INTO rt1 SELECT * FROM z1"); in testset_rtree()
1677 speedtest1_exec( in testset_orm()
1875 speedtest1_exec("COMMIT;"); in testset_orm()
1940 speedtest1_exec( in testset_trigger()
1959 speedtest1_exec( in testset_trigger()
2023 speedtest1_exec("BEGIN"); in testset_trigger()
2029 speedtest1_exec("COMMIT"); in testset_trigger()
2032 speedtest1_exec("CREATE TABLE t5(t TEXT PRIMARY KEY, i INTEGER);"); in testset_trigger()
2034 speedtest1_exec("INSERT OR IGNORE INTO t5 SELECT t, i FROM z1"); in testset_trigger()
2037 speedtest1_exec( in testset_trigger()
2088 speedtest1_exec("COMMIT"); in testset_trigger()
2096 speedtest1_exec( in testset_trigger()
2129 speedtest1_exec("COMMIT"); in testset_trigger()
2484 speedtest1_exec("PRAGMA temp_store=memory"); in main()
2487 speedtest1_exec("PRAGMA mmap_size=%d", mmapSize); in main()
2489 speedtest1_exec("PRAGMA threads=%d", nThread); in main()
2491 speedtest1_exec("PRAGMA key('%s')", zKey); in main()
2494 speedtest1_exec("PRAGMA encoding=%s", zEncoding); in main()
2497 speedtest1_exec("PRAGMA auto_vacuum=FULL"); in main()
2499 speedtest1_exec("PRAGMA auto_vacuum=INCREMENTAL"); in main()
2502 speedtest1_exec("PRAGMA page_size=%d", pageSize); in main()
2505 speedtest1_exec("PRAGMA cache_size=%d", cacheSize); in main()
2507 if( noSync ) speedtest1_exec("PRAGMA synchronous=OFF"); in main()
2509 speedtest1_exec("PRAGMA locking_mode=EXCLUSIVE"); in main()
2512 speedtest1_exec("PRAGMA journal_mode=%s", zJMode); in main()
2561 speedtest1_exec(zSql); in main()
2571 speedtest1_exec(zSql); in main()