Sounds like me…
I think that cache the Tag query will help from the performance aspect, but it still will be a bit ugly…
(*the view it self is cached)
What database engine are you using? (I’ve possibly got an idea, but it would be PostgreSQL-specific. If you’re using something else, then I’m not going to pursue it.)
For development sqlite, BUT I using docker, so I can switch…
What you thinking will solve it ?
Briefly, what I was thinking about was creating another table having an ArrayField column, and using the PostgreSQL contained_by function to do your search. (There may be a little more to it than that - I wanted to verify my idea before posting all the details, but that’s the gist of it.)
1 Like
Sound really complicated…
I will try to do it…