Please avoid using LIKE in queries when targeting the Comments table. This is resource killing for the server as the Comments table contains nearly 50 million rows.
json_metadata is FTS (Full Text Search ) enabled. You can use CONTAINS() predicate.
Replace json_metadata like '%uganda%' with CONTAINS(json_metadata, 'uganda') in your queries. It will execute MUCH faster and won't penalize other users!
Hi Arcange,
thank you very much for the hint!
Regards, Achim