Post A2249csWsmVnWxgfDM by glaurungo@niu.moe
 (DIR) More posts by glaurungo@niu.moe
 (DIR) Post #A2249c5Fpz6348dJPU by ayo@lonely.town
       2020-12-09T14:59:11Z
       
       0 likes, 0 repeats
       
       Me: Log slow queries so that I can optimize the advanced search function.Users: Create complex nested filters with 50+ tags and traits.That will never be fast. :cry_konata:
       
 (DIR) Post #A2249csWsmVnWxgfDM by glaurungo@niu.moe
       2020-12-09T16:52:27Z
       
       0 likes, 0 repeats
       
       @ayo Well, technicallyif they save those queries, you could predict that they're going to use them, and keep a prepared cached response for the time that they doNothing faster than that.Technically.
       
 (DIR) Post #A2249dO4zTkV6oRrOK by wolf480pl@mstdn.io
       2020-12-09T18:02:51Z
       
       0 likes, 0 repeats
       
       @glaurungo @ayo Slows down inserts, but then again, how often does a new VN appear?