View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001895 | Composr | search | public | 2015-05-06 18:24 | 2015-05-08 12:49 |
| Reporter | Chris Graham | Assigned To | Chris Graham | ||
| Severity | Feature-request | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0001895: Improve keyword search efficiency | ||||
| Description | Keywords are currently stored in a space-separated string, with one table row per content item. This is logical in the sense that there is a direct tie between content and meta row. However, it is not correctly normalised from a database design perspective and not efficient for searching (as indexing isn't running on individual keywords). Change it to have the keywords separated out. For each keyword of each content item, there would be a database row. | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | 4 | ||||
| Sponsorship open | |||||
