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

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