#4394 - Search optimisations
-
By Chris Graham
- Added
- 6 views
| Identifier | #4394 |
|---|---|
| Issue type | Trivial issue (does not break functionality) |
| Title | Search optimisations |
| Status | Completed |
| Handling member | Chris Graham |
| Version | 10.0.31 |
| Addon | search |
| Description | Fix 2 issues which may harm search performance. These are likely only serious problems on very old MySQL versions. However, we can still resolve them for a more logical product. 1) Meta-keyword search should only either do full-text, or full query match - trying to do both will significantly harm query performance. 2) Custom field querying does not need any c_name clauses, as these exist just to select the right table for catalogue searches. The wrong table is impossible for a custom field search. |
| Steps to reproduce | |
| Funded? | No |
| Commits | Fixed MANTIS-4394 (Search optimisations) (961d8253) · Commits · Composr ecosystem / Composr · GitLab |
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
There have been no comments yet