SQLite Forum

Performance Issue: How can I increase a performance?
Login
1. CREATE TABLE item (
    date_time TIMESTAMP NOT NULL,
    item_id INTEGER NOT NULL,
    list_id VARCHAR NOT NULL,
    unique_id VARCHAR(36),
    object_type INTEGER,
    author_id INTEGER,
    guid VARCHAR(36),
    editor_id INTEGER,
    created TIMESTAMP,
    folder VARCHAR(255),
    type VARCHAR(128),
    leaf_ref VARCHAR(64),
    uri VARCHAR(255),
    content_type VARCHAR(255),
    file_ref VARCHAR(255),
    title VARCHAR(128),
    modified TIMESTAMP,
    tag INTEGER,
    related VARCHAR(64),
    redirect VARCHAR(64),
    parent_guid VARCHAR(36),
    relocated INTEGER(1) DEFAULT 0,
    attributes JSON,
    keyword VARCHAR,
    deleted_date_time TIMESTAMP
)

2. I've showed that

3.
```
0|Trace|0|0|0||00|
1|String8|0|1|0|158a499e-4432-4073-a73b-9396cae17f42|00|
2|Integer|10209335|2|0||00|
3|Int64|0|3|0|1500007910000|00|
4|Goto|0|45|0||00|
5|OpenRead|0|2|0|25|00|
6|OpenRead|1|13080994|0|keyinfo(1,BINARY)|00|
7|SeekGe|1|42|1|1|00|
8|IdxGE|1|42|1|1|01|
9|IdxRowid|1|4|0||00|
10|Seek|0|4|0||00|
11|Column|0|1|5||00|
12|Ne|2|41|5|collseq(BINARY)|6c|
13|Column|0|16|6||00|
14|Ne|3|41|6|collseq(BINARY)|6b|
15|Column|0|0|8||00|
16|Column|0|1|9||00|
17|Column|1|0|10||00|
18|Column|0|3|11||00|
19|Column|0|4|12||00|
20|Column|0|5|13||00|
21|Column|0|6|14||00|
22|Column|0|7|15||00|
23|Column|0|8|16||00|
24|Column|0|9|17||00|
25|Column|0|10|18||00|
26|Column|0|11|19||00|
27|Column|0|12|20||00|
28|Column|0|13|21||00|
29|Column|0|14|22||00|
30|Column|0|15|23||00|
31|Column|0|16|24||00|
32|Column|0|17|25||00|
33|Column|0|18|26||00|
34|Column|0|19|27||00|
35|Column|0|20|28||00|
36|Column|0|21|29|0|00|
37|Column|0|22|30||00|
38|Column|0|23|31||00|
39|Column|0|24|32||00|
40|ResultRow|8|25|0||00|
41|Next|1|8|0||00|
42|Close|0|0|0||00|
43|Close|1|0|0||00|
44|Halt|0|0|0||00|
45|Transaction|0|0|0||00|
46|VerifyCookie|0|3|0||00|
47|TableLock|0|2|0|item|00|
48|Goto|0|5|0||00|
```

4. I've run ANALYZE it didn't give some output