aboutsummaryrefslogtreecommitdiffhomepage
path: root/app/DoctrineMigrations/Version20190601125843.php
Commit message (Collapse)AuthorAgeFilesLines
* Use two indexes instead of one for hashed urlsJeremy Benoist2019-06-051-23/+3
| | | | | 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.
* Use hash given url to avoid duplicateJeremy Benoist2019-05-291-0/+74
Using hashed url we can ensure an index on them to ensure it's fast.