Its a very big forum, around 0.5 million topics and 10 thousands tags, which are on each topic, 3-4 in number. Multiple tags search query takes very very long time, how to fix this ?

Can you paste in the slow query using mini profiler

here is the complete miniprofiler details. please see http://trail.lawus1.com/search.html

I see. So in this example, it definitely is requiring each tag individually. I imagine the performance impact is the use of IN and then doing it 3 times (one for each tag). I also wonder if the search can be smarter about this? Only use IN when multiple tags are provided, otherwise use = If you alter your search to tags:wa,gastroenterology,female does it work better? Granted, it changes the query, as it won’t be topics that have all three, but topics that have any of the three. Right now tags does not have a performant way to do AND and that is being requested at [image] Does multiple tag search support AND vs OR? Feature I think there is a bug when searching multiple tags. Here is the strange result I got on my Discourse: [image] Based on the search, there should be 8 results. But it displays 9. The 2nd result is correct, but not the 1st one. I wonder if the issue with the hyphen, since the mistaken result also contains the a tag that includes some of search terms ( -reports). The issue does not appear when searching for just committee-reports. ping @alehandrof, you might find this interesting

I’ll just throw in some food for thought here. It might be nice to have a URL structure to support searching by multiple tags. This could be #wordpress AND #embedding https://meta.discourse.org/tags/wordpress&embedding This could be #wordpress OR #embedding https://meta.discourse.org/tags/wordpress|embedding

[image] clay: I’ll just throw in some food for thought here. It might be nice to have a URL structure to support searching by multiple tags. https://meta.discourse.org/tags/intersection/docker/email

Cool! I didn’t know you could do that. Thanks!

Multiple Tags search query takes too long ? - big forum

Product Support

Falco (Falco) April 7, 2017, 4:08pm 8

https://meta.discourse.org/tags/intersection/docker/email

Topic		Replies	Views
Does multiple tag search support AND vs OR? Feature completed	11	4558	June 2, 2017
Paginating while searching for multiple tags Development	2	913	September 8, 2016
Filtering by multiple tags Product Support	19	3781	February 25, 2021
Advanced Search combining "AND" and "OR" for tags Product Support search , tags	1	464	September 13, 2022
Multiple mandatory tags Product Support	8	992	September 13, 2022

Multiple Tags search query takes too long ? - big forum

Related topics