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 al…

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|…

[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

Multiple Tags search query takes too long ? - big forum

Product Support

clay (Clay Heaton) April 7, 2017, 4:19pm 9

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

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

Multiple Tags search query takes too long ? - big forum

Related topics