логEnter SQL statements terminated with a ";"
sqlite> .load tablefunc.dll
sqlite> .timer ON
sqlite> pragma page_size;
1024
CPU Time: user 0.000000 sys 0.000000
sqlite> pragma page_size = 4096;
CPU Time: user 0.000000 sys 0.000000
sqlite> pragma page_size;
4096
CPU Time: user 0.000000 sys 0.000000
sqlite> pragma cache_size;
2000
CPU Time: user 0.000000 sys 0.000000
sqlite> pragma cache_size = 400000;
CPU Time: user 0.000000 sys 0.000000
sqlite> pragma cache_size;
400000
CPU Time: user 0.000000 sys 0.000000
sqlite> create temp table tmp_facts(rowid int);
CPU Time: user 0.000000 sys 0.000000
sqlite> select intrange2table (1,10000000,1,'tmp_facts');
CPU Time: user 112.788723 sys 430.500360
sqlite> create table facts(a1 int,a2 int,a3 int,a4 int);
CPU Time: user 0.000000 sys 0.000000
sqlite> insert into facts
...> select
...> cast(abs(random())/9223372036854775807.*18 as int),
...> cast(abs(random())/9223372036854775807.*18 as int),
...> cast(abs(random())/9223372036854775807.*18 as int),
...> cast(abs(random())/9223372036854775807.*18 as int)
...> from tmp_facts;
CPU Time: user 42.713074 sys 1.185608
sqlite> create index facts_a1_idx on facts(a1);
CPU Time: user 68.624840 sys 0.702005
sqlite> create index facts_a3_idx on facts(a3);
CPU Time: user 68.250438 sys 0.530403
sqlite> create index facts_a2_idx on facts(a2);
CPU Time: user 68.702840 sys 0.514803
sqlite> create index facts_a4_idx on facts(a4);
CPU Time: user 67.127230 sys 0.577204
sqlite> select count(*) from facts where a1=2 and a2=2 and a3=2 and a4=2;
112
CPU Time: user 1.138807 sys 0.000000
sqlite> select count(*) from facts where a1=2;
555739
CPU Time: user 0.171601 sys 0.000000
sqlite> select count(*) from facts where a1=2;
555739
CPU Time: user 0.234002 sys 0.000000
sqlite> select count(*) from facts where a1=2;
555739
CPU Time: user 0.280802 sys 0.000000
sqlite> select count(*) from facts where a1=2;
555739
CPU Time: user 0.171601 sys 0.000000
sqlite> create index facts_complex_idx on facts(a1,a2,a3,a4);
CPU Time: user 97.765827 sys 1.092007
sqlite> select count(*) from facts indexed by facts_a1_idx where a1=2;
555739
sqlite> select count(*) from facts where a1=2 and a2=2 and a3=2 and a4=2;
112
CPU Time: user 0.015600 sys 0.000000
sqlite> select count(*) from facts where a1=2 and a2=2 and a3=2 and a4=2;
112
CPU Time: user 0.000000 sys 0.000000