Re: Support and Updates | 10/23: Who Quoted Me? Released | Log Bugs/Requests on github.com/slaent/issues/issues

By reilo Go To PostFigured out the slow downs being caused is by the new who quoted me query. I'll need to disable it until tonight when I can investigate what the issue is. Sorry about that!

Even though it's back now, definitely noticed the difference when you hit quote and it took a second or two to populate the response field. What'd you change from your earlier implementation to this current one?

By Angelus Errare Go To PostEven though it's back now, definitely noticed the difference when you hit quote and it took a second or two to populate the response field. What'd you change from your earlier implementation to this current one?

Sharp rightly pointed out that I had the wrong index. Due to a specific Postgres configuration he made, the query planner wasn't going against this new index, so we had to add another index to make it work. That fixed it and now the execution time is sub 1ms for users with 0 posts and up to 7ms at most for users with some posts.

By reilo Go To PostSharp rightly pointed out that I had the wrong index. Due to a specific Postgres configuration he made, the query planner wasn't going against this new index, so we had to add another index to make it work. That fixed it and now the execution time is sub 1ms for users with 0 posts and up to 7ms at most for users with some posts.

Word. solid work mang.