Comments (4)
Query 257a6846e9aa2f42d6276e58c803e1e3 has a similar problem:
SELECT
`dav_shares`.`principaluri`,
`dav_shares`.`resourceid`
FROM
`oc_dav_shares` `dav_shares`
WHERE
(`dav_shares`.`type` = ?)
AND (`dav_shares`.`resourceid` = ?)
To improve both queries we will need two new indices:
- (resourceid, access)
- (resourceid, type)
from server.
@ChristophWurst should we do this automatically with a db migration? or is there another preferred method?
from server.
It depends (tm). If we can assume that the table is not insanely big we can apply the index with a migration. If the table is big we should only adapt the existing migration that creates the table. This will add the index for new setups. For existing ones we can use the "missing index" events/listeners.
from server.
Okay, I'll get working on it
from server.
Related Issues (20)
- [Bug]: Label is missing for enforced password for link share
- Predict database migration impact of upgrades HOT 1
- [Bug]: "dirty table reads" after Upgrade to 29.0.2 HOT 1
- Redesign search UI HOT 5
- [Bug]: 403 Forbidden on public shares HOT 3
- [Bug]: Default setting for download limit not adhered to
- Can development Kkfileviwer plug HOT 1
- Add expire mechanism for preview images HOT 2
- [Bug]: Temporary Error on Login. Even after update to NC 29 HOT 1
- [Bug]: "Temporary Error" on Login, even after Upgrade to NC 29 HOT 5
- Resolving references from public share
- Last login date (user:lastseen) does not work for desktop clients
- [Bug]: TypeError: r is not a function logreader-main.mjs HOT 1
- [Bug]: Drag'n'Drop to a folder not correctly detected on safari
- Public webdav does full filesystem setup of share owners
- [Bug]: rename file action is not possible and loads document instead HOT 1
- oc_filecache: optimization structure > UNSIGNED!
- [Bug]: Missing index for oc_appconfig.lazy
- NC30 UI refresh cleanup
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from server.