diff options
| author | Jeremy Benoist <jeremy.benoist@gmail.com> | 2019-06-05 10:51:06 +0200 |
|---|---|---|
| committer | Jeremy Benoist <jeremy.benoist@gmail.com> | 2019-06-05 10:53:15 +0200 |
| commit | 70df4c335965a9562cc24d3ccea0a6ed1a23b7b1 (patch) | |
| tree | a0c398645e5d340940cf25fab9cab46eb7903e86 /app/DoctrineMigrations/Version20170501115751.php | |
| parent | f3bfb875e94021a93e24a41fbc0f8d86d4dee378 (diff) | |
| download | wallabag-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/DoctrineMigrations/Version20170501115751.php')
0 files changed, 0 insertions, 0 deletions