#2419 - Catalogue entry results are doubled.
| Identifier | #2419 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Catalogue entry results are doubled. |
| Status | Closed (not fixable) |
| Handling member | Chris Graham |
| Addon | search |
| Description | When searching for keywords/tags the results shown are correct, but the count is doubled. |
| Steps to reproduce | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".


Comments
(Click to enlarge)
It is because of multiple criteria hitting a result (probably here a meta keyword hit combined with a textual hit). We can de-dupe the displayed results to some extent, but to de-dupe counted results would requiring loading up everything across all paginations (not just the tallies the DB gives us), and then doing a full scan.
I'm sure we could improve it, like give accuracy on smaller sets. But the search code is already incredibly complex, so it's something I'd avoid.
Honestly a better long-term solution is if we moved away from MySQL search, to a textual indexing system. There's a tracker issue for that somewhere. These systems pre-index content based on how it's displayed, rather than aggregating criteria in real-time, so don't have the same limitations.