Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | Use two indexes instead of one for hashed urls | Jeremy Benoist | 2019-06-05 | 1 | -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 duplicate | Jeremy Benoist | 2019-05-29 | 1 | -0/+74 |
Using hashed url we can ensure an index on them to ensure it's fast. |