SQLite Forum

Performance Issue: How can I increase a performance?
Login
I have only one table

```sql
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
)
```