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 /tests | |
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 'tests')
-rw-r--r-- | tests/Wallabag/CoreBundle/Controller/EntryControllerTest.php | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/tests/Wallabag/CoreBundle/Controller/EntryControllerTest.php b/tests/Wallabag/CoreBundle/Controller/EntryControllerTest.php index a6fd3fff..e9c12c49 100644 --- a/tests/Wallabag/CoreBundle/Controller/EntryControllerTest.php +++ b/tests/Wallabag/CoreBundle/Controller/EntryControllerTest.php | |||
@@ -265,6 +265,9 @@ class EntryControllerTest extends WallabagCoreTestCase | |||
265 | $this->assertContains('/view/', $client->getResponse()->getTargetUrl()); | 265 | $this->assertContains('/view/', $client->getResponse()->getTargetUrl()); |
266 | } | 266 | } |
267 | 267 | ||
268 | /** | ||
269 | * This test will require an internet connection. | ||
270 | */ | ||
268 | public function testPostNewOkUrlExistWithRedirection() | 271 | public function testPostNewOkUrlExistWithRedirection() |
269 | { | 272 | { |
270 | $this->logInAs('admin'); | 273 | $this->logInAs('admin'); |