projects
/
id3fs.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
tweak indexes in schema
[id3fs.git]
/
lib
/
ID3FS
/
DB.pm
diff --git
a/lib/ID3FS/DB.pm
b/lib/ID3FS/DB.pm
index
deaa16e
..
11b5525
100644
(file)
--- a/
lib/ID3FS/DB.pm
+++ b/
lib/ID3FS/DB.pm
@@
-362,7
+362,7
@@
sub unindex
sub prune_directories
{
my($self)=@_;
sub prune_directories
{
my($self)=@_;
- my $sql=("SELECT name, id FROM paths
ORDER BY name
\n");
+ my $sql=("SELECT name, id FROM paths\n");
my $pathsref=$self->cmd_rows($sql);
my @ids=();
for my $pathpair (@$pathsref)
my $pathsref=$self->cmd_rows($sql);
my @ids=();
for my $pathpair (@$pathsref)
@@
-565,15
+565,16
@@
CREATE TABLE files_x_tags (
FOREIGN KEY(tags_id) REFERENCES tags(id) ON DELETE CASCADE ON UPDATE CASCADE
);
FOREIGN KEY(tags_id) REFERENCES tags(id) ON DELETE CASCADE ON UPDATE CASCADE
);
-CREATE INDEX idx_files_id ON files (id)
-
CREATE INDEX idx_fxt_both ON files_x_tags (files_id, tags_id)
CREATE INDEX idx_fxt_both ON files_x_tags (files_id, tags_id)
-CREATE INDEX idx_fxt_files ON files_x_tags (files_id)
-
CREATE INDEX idx_fxt_tags ON files_x_tags (tags_id)
CREATE INDEX idx_fxt_tags ON files_x_tags (tags_id)
-CREATE INDEX idx_
tags_id ON tags (id
)
+CREATE INDEX idx_
files_id_name ON files (id, name
)
-CREATE INDEX idx_
tags_name ON tags (name
)
+CREATE INDEX idx_
files_name_id ON files (name, id
)
+CREATE INDEX idx_tags_id_parent_name ON tags (id, parents_id, name)
+
+CREATE INDEX idx_tags_parent_id_name ON tags (parents_id, id, name)
+
+CREATE INDEX idx_tags_name ON tags (name)