I have a Stock Entry table that has about 3 million entries. Browsing the Stock Entry doctype in List mode causes a query to run that looks like this:
select `_user_tags`, count(*)
from `tabStock Entry`
where coalesce(`tabStock Entry`._user_tags, '') in ('', ',')
group by _user_tags
order by _user_tags
This runs for about 3 minutes and if there are refreshes on the list view or if another user browses the list view another query runs. As you can imagine this stacks up and the Database is overwhelmed. I’ve been searching for awhile but does anyone know where the query is executed? Would like to disable it. Thanks.