diff options
| author | Přemysl Eric Janouch <p@janouch.name> | 2024-12-29 13:41:07 +0100 |
|---|---|---|
| committer | Přemysl Eric Janouch <p@janouch.name> | 2024-12-29 13:41:07 +0100 |
| commit | ce2e58b6bcdef7616d5426f3310ab09cdea92f32 (patch) | |
| tree | 08fa382743a37b8951f8de370f611412970a067f /initialize.sql | |
| parent | ca462ac0056cfe434acc8b8faf50a439ce3f8c91 (diff) | |
| download | gallery-ce2e58b6bcdef7616d5426f3310ab09cdea92f32.tar.gz gallery-ce2e58b6bcdef7616d5426f3310ab09cdea92f32.tar.xz gallery-ce2e58b6bcdef7616d5426f3310ab09cdea92f32.zip | |
Fix extremely slow removals
Diffstat (limited to 'initialize.sql')
| -rw-r--r-- | initialize.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/initialize.sql b/initialize.sql index 292c50b..436d34f 100644 --- a/initialize.sql +++ b/initialize.sql @@ -23,6 +23,7 @@ CREATE TABLE IF NOT EXISTS node( ) STRICT; CREATE INDEX IF NOT EXISTS node__sha1 ON node(sha1); +CREATE INDEX IF NOT EXISTS node__parent ON node(parent); CREATE UNIQUE INDEX IF NOT EXISTS node__parent_name ON node(IFNULL(parent, 0), name); |