How I can do a query to count the comments where a user is mentioned?

[Wilmer Caiza]

I tried the query below, but our jiraaction table has around 30 million records and it takes around 10 minutes to execute by each user.
I need to consider de archived issues for this reason I can't use JQL.

select count (id) from jiraaction ja where ja.actionbody like '%~userFilter%';

If you have any ideas I appreciate.

Thanks.

[Mirek]

Hi @Wilmer Caiza 

Maybe this could be helpful to get more accurate (and faster) query

https://confluence.atlassian.com/jirakb/how-to-find-all-the-comments-related-to-one-user-in-the-database-385909306.html

[Wilmer Caiza]

Thanks Mirek, I will review it.