Open florianschroen opened 5 months ago
This is an index that is already created automatically.
Did you run occ db:add-missing-indices
recently? Indexes are only created when running this command as the creation might take a long time.
When there was a mention on the admin page to do so, then yes. Otherwise no. (too much time has passed to remember what I did exactly)
Maybe I can find some info in the bash history.
Please try to run the command anyway and see if it makes a difference.
did it now. now output so far, so no missing indices
~# occ db:add-missing-indices
~# echo $?
0
Hi,
i just want to share my experience and fix.
I installed the plugin for the first time on a uptodate nc docker instance with a separate pg container.
The pageload was very slow. first preview request were answered, some got HTTP 500.
After digging into the DB, I noticed that the queries were extremely slow. which leaded to this pg log lines (and many more):
so i digged into the index of the table
oc_filecache
.there is no index for the problematic queries which indexes
storage
andpath_hash
.so i added the missing index:
...and got a significantly increase of the preview/page load speed.
I am not into the nc-plugin code to check if this is individual problem of my installation / migration paths. Or if there is something missing for auto-creation of this index.
So can someone verify this, please?