[Boots]

Originally Posted by MicroHellas

Just commenting in such a topic, says nothing more other than someone wants to appear smarty. Include in your post what do you think as optimised query, and also be more specific on your meaning of "lot of posts", so the users can compare it with their forum's posts. So "Lot of posts" means 1000, 10000, 100000 or what?

In my case the forum has 2,162,154 posts and the query takes about 3-5 seconds. You could have clicked on the link to my forum to see the post total btw. I tried out the mod, found the query to be slow and removed it. I don't have time to optimize the query.

And don't forget the saying: "If you don't have something good to say, is better to keep your mouth close".

This doesn't apply in this case. People need to know the good and the bad when it comes to these mods. An inexperienced forum owner could cripple his forum from installing something without considering the negative effects it could have on performance.

Thank you and Merry Christmas to you and to your family.
Maria

Same to you