#1895 - Improve keyword search efficiency

Identifier #1895
Issue type Feature request or suggestion
Title Improve keyword search efficiency
Status Completed
Handling member Chris Graham
Addon search
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.
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".

Rating

Unrated