Revert "Merge branch '497530-introduce-character-limit' into 'master'"

What does this MR do and why?

This reverts merge request !168066 (merged), we have managed to improve performance significantly by introducing an inverted index

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.