diff options
| author | Silvio Rhatto <rhatto@riseup.net> | 2020-12-05 17:07:09 -0300 |
|---|---|---|
| committer | Silvio Rhatto <rhatto@riseup.net> | 2020-12-05 17:07:09 -0300 |
| commit | 56c2cc72b9e4f65d94edab5f4c58633322dc43f8 (patch) | |
| tree | 1602e83b41b95e2cd0ba026fdf26ffa0f3cd8471 /data/schema | |
| parent | f9b94e3ba677fd19c311fdde7cd9da8709953000 (diff) | |
| download | semanticscuttle-56c2cc72b9e4f65d94edab5f4c58633322dc43f8.tar.gz semanticscuttle-56c2cc72b9e4f65d94edab5f4c58633322dc43f8.tar.bz2 | |
Fix: create an index at sc_bookmarks2tags table
This index increases the performance of queries that selects
tags from a given bookmark.
Diffstat (limited to 'data/schema')
| -rw-r--r-- | data/schema/7.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/data/schema/7.sql b/data/schema/7.sql new file mode 100644 index 0000000..28694fa --- /dev/null +++ b/data/schema/7.sql @@ -0,0 +1 @@ +CREATE INDEX sc_bookmarks2tags_index ON sc_bookmarks2tags(tag); |