Skip to main content ↑ ↓
Slow Query with large forum Started by tino · · Read 3548 times 0 Members and 1 Guest are viewing this topic. previous topic - next 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.