Skip to main content
Topic: Slow Query with large forum (Read 678 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Re: Slow Query with large forum

Reply #15
I have not gotten mine to the point where it is using temporary and thus far I'm only in the 5 digits vs your 6 digit initial.

1.1.7 will support sub selects, that was part of that limit issue you helped debug.  We could query the attach table and if empty force use avatars on index to false for that query.

Like you noted a bit of a corner case but that is what makes it interesting.
Be safe, Be kind, Happy Programing