aboutsummaryrefslogtreecommitdiffhomepage
path: root/app/AppCache.php
diff options
context:
space:
mode:
authorJeremy Benoist <jeremy.benoist@gmail.com>2019-06-05 10:51:06 +0200
committerJeremy Benoist <jeremy.benoist@gmail.com>2019-06-05 10:53:15 +0200
commit70df4c335965a9562cc24d3ccea0a6ed1a23b7b1 (patch)
treea0c398645e5d340940cf25fab9cab46eb7903e86 /app/AppCache.php
parentf3bfb875e94021a93e24a41fbc0f8d86d4dee378 (diff)
downloadwallabag-70df4c335965a9562cc24d3ccea0a6ed1a23b7b1.tar.gz
wallabag-70df4c335965a9562cc24d3ccea0a6ed1a23b7b1.tar.zst
wallabag-70df4c335965a9562cc24d3ccea0a6ed1a23b7b1.zip
Use two indexes instead of one for hashed urls
When using `OR` in a where clause, a composite index can't be used. We should use a `UNION` to take advantages of it. Instead, create 2 indexes on each hashed urls and make 2 queries to find an url. It'll be faster than the previous solution.
Diffstat (limited to 'app/AppCache.php')
0 files changed, 0 insertions, 0 deletions