[]JoshPet said:
I *think* it's the show all posts by a user.
View someone's profile and click "Show all this user's posts".
although maybe not - as I see there's a board query with it as well. [/]
No , it is not ...
"Show all this user's posts" is very 'light' to MySQL , almost can be done in 0.5 seconds.
But this strange query is very heavy , almost cause my server down.
The code is in dosearch.php , line 249 - 261 (UBBthreads 6.4.2)
What action (page ? link ? button ?) cause this query ?
I don't think it is caused by search.php , because search.php's action is another heavy 'SQL LIKE' query , not this strange/heave query. Furthermore , I had already removed 'Submit' button in search page , that no one can search.