Hello, Richard, thanks for quick reply.
Unfortunately, no, there is no way. On our servers we have big number
of entities that represent client data. Data for different clients can
be read at any given point of time by clients and by a bunch of daemons
responsible for different maintenance jobs. Recently we have switched
our central index file from hand made, transation-less format to sqlite.
We have daemon that provides API both for clients and for maintenance daemons.
So, there is roughly 500 requests per second to the daemon. Most of requests
require simple data to be extracted, but since now it takes more time to read
that data, we observe considerable CPU usage growth. This growth is not
sever for us at all. But I am a performance paranoid type of a person :D
So that's why I am curios if maybe anything can be tuned inside of sqlite.
And seeing how removing stat table reduces time 4x times I thought
maybe there are other ways around.
Unfortunately database structure is a of commercial secret.
But I hope modified content of sqlite_stat* will shed some light.
PART 1
INSERT INTO sqlite_stat1 VALUES('AAA','AAA','4711 2 2 1');
INSERT INTO sqlite_stat1 VALUES('BBB','BBB_idx','18249 3');
INSERT INTO sqlite_stat1 VALUES('BBB','BBB','18249 22 1');
INSERT INTO sqlite_stat1 VALUES('CCC','CCC_idx','54 3 1');
INSERT INTO sqlite_stat1 VALUES('DDD',NULL,'478');
INSERT INTO sqlite_stat1 VALUES('EEE','EEE_idx','836 1');
INSERT INTO sqlite_stat1 VALUES('FFF',NULL,'16');
INSERT INTO sqlite_stat1 VALUES('GGG','GGG','7 1');
INSERT INTO sqlite_stat1 VALUES('HHH',NULL,'13');
INSERT INTO sqlite_stat1 VALUES('III','III_idx','2918 2 1');
INSERT INTO sqlite_stat1 VALUES('JJJ','JJJ','2915 1 1');
INSERT INTO sqlite_stat1 VALUES('KKK','KKK_idx','7070 3');
INSERT INTO sqlite_stat1 VALUES('KKK','KKK','7070 1');
INSERT INTO sqlite_stat1 VALUES('LLL','LLL_idx','2973 595 2 1');
INSERT INTO sqlite_stat1 VALUES('LLL','LLL','2973 2 1');
INSERT INTO sqlite_stat1 VALUES('MMM','MMM_idx1','7942 3 3');
INSERT INTO sqlite_stat1 VALUES('MMM','MMM_idx2','7942 1324 1');
INSERT INTO sqlite_stat1 VALUES('MMM','MMM_idx3','7942 3 1');
INSERT INTO sqlite_stat1 VALUES('NNN','NNN','223 2 1');
INSERT INTO sqlite_stat1 VALUES('OOO',NULL,'6');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','14 14 1','306 306 315','216 216
315',X'0402010200d9020098');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','12 12 1','445 445 449','286 286
449',X'04020101011f0270');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','520 520 523','313 313
523',X'04020101013a0267');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','9 9 1','600 600 602','341 341
602',X'0402010101560261');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','702 702 709','386 386
709',X'040201020183020096');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','797 797 802','432 432
802',X'0402010201b1020094');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','1 1 1','1047 1047 1047','557 557
1047',X'04020101022e0209');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','2 2 1','1571 1571 1571','946 946
1571',X'0402010103b30206');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','12 12 1','1733 1733 1739','1090
1090 1739',X'040201020443020094');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','15 15 1','1882 1882 1889','1168
1168 1889',X'0402010104910277');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','9 9 1','1916 1916 1917','1183 1183
1917',X'0402010104a00261');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','2040 2040 2042','1250
1250 2042',X'0402010104e30276');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','4 4 1','2092 2092 2095','1277 1277
2095',X'0402010204fe020223');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','2210 2210 2220','1363
1363 2220',X'040201020554020234');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','9 9 1','2606 2606 2611','1621 1621
2611',X'0402010206560200a3');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','4 4 1','2618 2618 2619','1625 1625
2619',X'04020102065a020093');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','9 9 1','2932 2932 2935','1801 1801
2935',X'04020101070b0270');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','1 1 1','3143 3143 3143','1930 1930
3143',X'04020102078f020163');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','3276 3276 3285','1992
1992 3285',X'0402010207d302024d');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','1 1 1','3667 3667 3667','2262 2262
3667',X'0402010208e4020163');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','3727 3727 3731','2292
2292 3731',X'0402010109020275');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','3950 3950 3955','2436
2436 3955',X'0402010209970200f4');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','4 4 1','4189 4189 4191','2578 2578
4191',X'040201020a2b020089');
INSERT INTO sqlite_stat4 VALUES('AAA','AAA','11 11 1','4649 4649 4659','2836
2836 4659',X'040201020b46020340');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','15 1','204 216','88
216',X'030601526e1cde35d6764d25');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','15 1','227 229','94
229',X'030601526f6583341a1ca41a');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','15 1','242 252','95
252',X'030601526f6ca12ef8b9dc22');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','15 1','257 266','96
266',X'030601526f6d5a30966cc121');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','15 1','272 275','97
275',X'030601526f6f0634b9ec441b');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','20 1','523 540','174
540',X'030601529b163d1e919ffb4a');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','20 1','543 555','175
555',X'030601529b19ac0302140f45');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','7 1','965 969','355
969',X'030601534ebd800000011f0e');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','2 1','2026 2027','838
2027',X'030601536b4f470000018f62');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','3 1','4055 4055','1675
4055',X'0306015388c90c000002d716');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','3 1','6081 6083','2359
6083',X'030602538c8852000002d3011e');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','26 1','7670 7683','3079
7683',X'03060253b85cd300000395017b');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','26 1','7747 7758','3104
7758',X'03060253ba3621000002ab0197');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','26 1','7936 7954','3191
7954',X'03060253bac839000001bd01b8');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','2 1','8110 8111','3262
8111',X'03060153bc664a0000022c5e');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','11 1','8521 8529','3447
8529',X'03060253c008d40000023101dc');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','12 1','8570 8579','3467
8579',X'03060253c05adc0000036301dd');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','2 1','10138 10139','4173
10139',X'03060253df68aa3ade0fd701a6');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','7 1','10199 10202','4200
10202',X'03060153dfaba531eda3d60d');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','2 1','12167 12167','5091
12167',X'030601540990dc05ddd0990b');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','2 1','14195 14195','6023
14195',X'030601542c0f76000003080b');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','7 1','14821 14824','6323
14824',X'0306015436a19c000000810d');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','2 1','16223 16223','6991
16223',X'03060154537b700000031a5b');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB_idx','7 1','18173 18175','7897
18175',X'0306015487238d135d7c280c');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','389 1','97 387','5
387',X'03010606540ff50a0493ac17');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','401 1','486 782','6
782',X'03010607542e72690000028c');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','461 1','887 952','7
952',X'0301060852fe3c7d1664e2b8');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','239 1','1348 1362','8
1362',X'030106095263c5ca1562ae6f');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','240 1','1587 1773','9
1773',X'0301060a5433d5af00000068');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','1584 1','1827 2027','10
2027',X'0301060b53a44f3500000386');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','468 1','3411 3758','11
3758',X'0301060c5409c8af25299ee9');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','454 1','3879 4055','12
4055',X'0301060d53a1ab4b390a74a5');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','119 1','4333 4435','13
4435',X'0301060e54202a801bb0c744');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','976 1','4460 5204','21
5204',X'03010616538ac8d8000000d4');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','955 1','5436 6083','22
6083',X'03010617538a600a00000308');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','4353 1','6787 8111','90
8111',X'0301065b53bdbc6a000000c2');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','4353 1','6787 10139','90
10139',X'0301065b543cc839000002bd');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','399 1','11222 11416','93
11416',X'0301065e53e39a8d2553562d');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','349 1','11630 11961','96
11961',X'03010661546620c80000003c');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','89 1','12026 12046','102
12046',X'030106675388b9ba00000067');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','52 1','12117 12167','104
12167',X'0301066954804c0e218c8782');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','246 1','12169 12407','105
12407',X'0301066a5485ac671f8cde53');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','87 1','12510 12538','111
12538',X'0301067053e5515927b667fd');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','128 1','12627 12668','116
12668',X'0301067553f472590efd80ce');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','128 1','13433 13552','162
13552',X'03020600a3547f2a72052ed151');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','8 1','14194 14195','252
14195',X'03020600fd53cfdab53781897b');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','934 1','14389 14871','285
14871',X'030206011e5389aa440000012b');
INSERT INTO sqlite_stat4 VALUES('BBB','BBB','1093 1','15660 16223','354
16223',X'0302060163540080ff1a045714');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','0 0 0','0 0
0',X'04040606547dd23f547dd23f30f1554c547dd23f30f1554c');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','1 1 1','1 1
1',X'04040606547dd4a5547dd4a522871530547dd4a522871530');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','2 2 2','2 2
2',X'04040606547dda61547dda611ee0dc9d547dda611ee0dc9d');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','3 3 3','3 3
3',X'04040606547ddb29547ddb29000a3cf6547ddb29000a3cf6');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','4 4 4','4 4
4',X'04040606547de492547de4920e30c08b547de4920e30c08b');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','5 5 5','5 5
5',X'04040606547de4fd547de4fd003822f2547de4fd003822f2');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','6 6 6','6 6
6',X'04040606547de9e3547de9e32a4efde1547de9e32a4efde1');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','7 7 7','7 7
7',X'04040606547dea2d547dea2d320f940c547dea2d320f940c');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','8 8 8','8 8
8',X'04040606547dedb6547dedb614cebb4e547dedb614cebb4e');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','9 9 9','9 9
9',X'04040606547dedd3547dedd3357e1c70547dedd3357e1c70');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','10 10 10','10 10
10',X'04040606547df2e0547df2e019139ab4547df2e019139ab4');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','11 11 11','11 11
11',X'04040606547df2eb547df2eb0da47f46547df2eb0da47f46');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','12 12 12','12 12
12',X'04040606547efcd7547efcd70c552622547efcd70c552622');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','37 1 1','13 13 13','13 13
13',X'040406065487fdf15406bed90925aeca5406bed90925aeca');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','37 1 1','13 20 20','13 20
20',X'040406065487fdf1541c3e2119800514541c3e2119800514');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','37 1 1','13 27 27','13 27
27',X'040406065487fdf1543fd25600000138543fd25600000138');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','37 1 1','13 34 34','13 34
34',X'040406065487fdf1544f06ec00000057544f06ec00000057');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','37 1 1','13 41 41','13 41
41',X'040406065487fdf15477b4db212f29e85477b4db212f29e8');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','37 1 1','13 45 45','13 45
45',X'040406065487fdf15486c2bc2c7b042a5486c2bc2c7b042a');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','37 1 1','13 48 48','13 48
48',X'040406065487fdf15487723428196f3a5487723428196f3a');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','50 50 50','14 50
50',X'0404060654894ca854894ca82fd32a2d54894ca82fd32a2d');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','51 51 51','15 51
51',X'0404060654896be554896be52542fddd54896be52542fddd');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','52 52 52','16 52
52',X'0404060654896cf854896cf83a356dac54896cf83a356dac');
INSERT INTO sqlite_stat4 VALUES('CCC','CCC_idx','1 1 1','53 53 53','17 53
53',X'0404060654897208548972081a21d6fb548972081a21d6fb');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','92 92','92
92',X'033302616c696a617761643140676d61696c2e636f6d02d4');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','112 112','112
112',X'03330161706572693230303740676d61696c2e636f6d7b');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','185 185','185
185',X'03490164616e61704064616e64796d61646570726f64756374696f6e732e636f6d6d');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','256 256','256
256',X'034702656a6f686e73746f6e406f33696e7465726e6174696f6e616c2e636f6d00e8');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','278 278','278
278',X'03290166656a6a40676e6f6d652e6f726717');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','371 371','371
371',X'0333026974642d74696d407a672e742d636f6d2e687201f2');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','464 464','464
464',X'0335026c697374734073716c6d61657374726f2e636f6d02ff');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','487 487','487
487',X'0339026d617070656e7a656c6c617240676d61696c2e636f6d0115');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','534 534','534
534',X'0331026d7175696e6c616e40676d61696c2e636f6d032a');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','537 537','537
537',X'0345016d73677061636b2d63406e6f7265706c792e6769746875622e636f6d30');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','540 540','540
540',X'0325026d77406d776c6162732e64650247');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','557 557','557
557',X'033b026e69636f6c6173627261696c6f40676d61696c2e636f6d020e');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','592 592','592
592',X'03370270616e74656c69735f3930407961686f6f2e636f6d0214');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','650 650','650
650',X'03510272616c662b73716c6974654072616d7365732d707972616d6964656e6261752e646500f5');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','704 704','704
704',X'0355027368616e74616e752e6e616d6a6f73686940627573696e6573732e75636f6e6e2e65647502cc');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','707 707','707
707',X'03370273686f6a692e6e40736f636b6574732e636f2e6a700278');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','710 710','710
710',X'033b0273696e6973612e6272616c6963407374726f676f2e687201f3');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','730 730','730
730',X'033b0173716c6974652d75736572734073716c6974652e6f72675b');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','743 743','743
743',X'033f0273746566616e69652e6b72616d6d6540756e696261732e636801bc');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','765 765','765
765',X'032b02743333406465762e756b722e6e657400c6');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','771 771','771
771',X'0333027463616e67303140686f746d61696c2e636f6d01f6');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','777 777','777
777',X'0335027468657864657231406e65747a65726f2e6e657402b6');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','793 793','793
793',X'033302756c726963682e74656c6c6540676d782e6465033b');
INSERT INTO sqlite_stat4 VALUES('EEE','EEE_idx','1 1','817 817','817
817',X'03330277696c6c406469676974616c6465762e636f6d021e');
INSERT INTO sqlite_stat4
VALUES('GGG','GGG','1','0','0',X'0233616e74697370616d5f6d6f76655f6c696d6974');
INSERT INTO sqlite_stat4 VALUES('GGG','GGG','1','1','1',X'0217666c616773');
INSERT INTO sqlite_stat4
VALUES('GGG','GGG','1','2','2',X'0231666f6c6465725f73706c69745f696e646578');
INSERT INTO sqlite_stat4
VALUES('GGG','GGG','1','3','3',X'023d666f6c6465725f7569645f76616c69646974795f6c617374');
INSERT INTO sqlite_stat4 VALUES('GGG','GGG','1','4','4',X'02196f6e5f737364');
INSERT INTO sqlite_stat4
VALUES('GGG','GGG','1','5','5',X'021d7265766973696f6e');
INSERT INTO sqlite_stat4
VALUES('GGG','GGG','1','6','6',X'02297374727563745f76657273696f6e');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','1 1 1','324 324 324','321 324
324',X'04040202536d12ab01350135');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','3 1 1','648 649 649','630 649
649',X'0404020253aaf46902960296');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','4 1 1','661 661 661','636 661
661',X'0404020253aaffa302a202a2');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','668 671 671','640 671
671',X'0404020253aaffe802ac02ac');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','965 965 965','853 965
965',X'0404020253bfe67d03d003d0');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','2 1 1','973 974 974','856 974
974',X'0404020253bfe9ea03da03da');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','1005 1007 1007','872
1007 1007',X'0404020253bff7c203fb03fb');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','1012 1013 1013','874
1013 1013',X'0404020253bff80404010401');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','1025 1027 1027','880
1027 1027',X'0404020253c00551040e040e');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','6 1 1','1030 1032 1032','881
1032 1032',X'0404020253c0055204130413');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','1051 1055 1055','890
1055 1055',X'0404020253c02e08042a042a');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','2 1 1','1298 1299 1299','1107
1299 1299',X'0404020253df9d02051b051b');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','1 1 1','1624 1624 1624','1392
1624 1624',X'0404020253fc8db006530653');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','1 1 1','1949 1949 1949','1673
1949 1949',X'04040202541c4af007a007a0');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','6 1 1','2062 2062 2062','1781
2062 2062',X'04040202542c0ede08130813');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','2139 2140 2140','1834
2140 2140',X'040402025432eca908660866');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','2149 2153 2153','1838
2153 2153',X'040402025433099808730873');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','2164 2164 2164','1848
2164 2164',X'040402025433fb84087d087d');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','2216 2219 2219','1892
2219 2219',X'040402025436346b08b308b3');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','1 1 1','2274 2274 2274','1928
2274 2274',X'040402025437e65b08ea08ea');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','2513 2516 2516','2130
2516 2516',X'040402025451099009d709d7');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','5 1 1','2560 2560 2560','2169
2560 2560',X'04040202545763c60a050a05');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','1 1 1','2599 2599 2599','2197
2599 2599',X'04040202545917480a290a29');
INSERT INTO sqlite_stat4 VALUES('III','III_idx','7 1 1','2668 2672 2672','2266
2672 2672',X'04040202546614990a760a76');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','112 112','112
112',X'0301017102');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','323 323','323
323',X'030201014402');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','413 413','413
413',X'030201019e02');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','424 424','424
424',X'03020101a902');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','468 468','468
468',X'03020101d502');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','647 647','647
647',X'030201028802');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','847 847','847
847',X'030201035002');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','971 971','971
971',X'03020103cc02');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1073 1073','1073
1073',X'030201043202');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1148 1148','1148
1148',X'030201047d02');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1284 1284','1284
1284',X'030201050502');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1295 1295','1295
1295',X'030201051002');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1308 1308','1308
1308',X'030201051d02');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1383 1383','1383
1383',X'030201056802');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1525 1525','1525
1525',X'03020105f602');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1619 1619','1619
1619',X'030201065402');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1768 1768','1768
1768',X'03020106e902');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1915 1915','1915
1915',X'030201077c02');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1943 1943','1943
1943',X'030201079802');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','1968 1968','1968
1968',X'03020107b102');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','2267 2267','2267
2267',X'03020108dc02');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','2271 2271','2271
2271',X'03020108e002');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','2399 2399','2399
2399',X'030201096002');
INSERT INTO sqlite_stat4 VALUES('JJJ','JJJ','1 1','2591 2591','2591
2591',X'0302010a2002');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','32 1','389 420','181
420',X'03022c00b6fb37bb38e4fe74ca5ec4c98d3b90611a');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','43 1','543 562','216
562',X'03022c00d9680701aee55e1e5b99c420ea9abb0c91');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','37 1','772 785','286
785',X'03022c011f64d7742e005100cc7cdefe2e04cc629e');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','30 1','1025 1040','339
1040',X'03022c0154a38ff329a3839f6927265259193a1760');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','55 1','1213 1260','386
1260',X'03022c0183e59224446d4b99c839d393d53fa43f7d');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','22 1','1384 1398','432
1398',X'03022c01b1dbd11372fd5046a84a02423aa1697363');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','36 1','1471 1487','457
1487',X'03022c01ca89a6204ee1aaa050f37a23df0f344f34');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','5 1','1568 1571','484
1571',X'03022c01e5611c0cb30459b33cc48a95d72cd8ea39');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','1 1','2357 2357','881
2357',X'03022c0372d3e9b13e80eef31fb413e55cef002640');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','21 1','2445 2462','926
2462',X'03022c039fdfc62f859e1278908d2c93b2ce5b6863');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','21 1','2476 2490','932
2490',X'03022c03a5b94aea45945f162a5b79d9a6efd57d5e');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','52 1','2712 2715','1090
2715',X'03022c0443197e806d7d1e83beb728b44541dec158');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','23 1','2970 2984','1168
2984',X'03022c04919cfb803d0e193a89a961d63207c3ac97');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','2 1','3142 3143','1223
3143',X'03022c04c8a56513be8612dbaaeeb1566a278b92df');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','28 1','3225 3247','1250
3247',X'03022c04e3ea118c7d8e88e8fbaf6defe2e479fb6e');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','37 1','3338 3344','1286
3344',X'03022c05071f5f30916faf0aa484ba06425c6a184b');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','1 1','3929 3929','1604
3929',X'03022c0645b7b8b9a25ac2b08e21f340bde5a6be22');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','37 1','4447 4451','1802
4451',X'03022c070b1a303561ccbaab2744d33ff663120bdc');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','1 1','4715 4715','1912
4715',X'03022c07795242d152313b0f7f4779c7baf0dfb75c');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','21 1','4764 4777','1941
4777',X'03022c079684a88ae7941e178cac2dded7fa9d3d1a');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','26 1','4973 4994','2002
4994',X'03022c07d3ba95fc5dce4f3a3b4a890e26bcd549a1');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','1 1','5501 5501','2270
5501',X'03022c08df75de7273df33827cece10b642ffa667a');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','10 1','6278 6287','2609
6287',X'03022c0a32f4f85b044037319f6a7314d87c07a44b');
INSERT INTO sqlite_stat4 VALUES('KKK','KKK_idx','32 1','6947 6963','2885
6963',X'03022c0b4698a18752cc6c105a1c72ac4327f399a8');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','785','785',X'022c1e7e6523357050361d43ca80217d045c');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','1571','1571',X'022c3b47f41b1d88149619d68237d1efbd1b');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','2357','2357',X'022c5877baa9e8f7a9372b3e8c314d44d534');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','3143','3143',X'022c740d5d8519a71e630cf1175040e2d918');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','3929','3929',X'022c8f66e559b758ec6de4c2fe8b8ef96f5b');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','4715','4715',X'022caa888cc912294e7d4d634fbecc05f232');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','5501','5501',X'022cc6b67cad202553a98a06d3feb4bf51f2');
INSERT INTO sqlite_stat4
VALUES('KKK','KKK','1','6287','6287',X'022ce2e3f8f96a8805b4f2ae613c41a0a895');
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
