[WetWired]

Originally Posted by rob01

how many queries this add?

in my forum is 9 :S

From the opening post:

Technical
This hack adds 1 query to showthread for each user who posts in that page (or only 1 for the logged in user by configuration). In addition, the first time a member's post or profile is accessed during a day (GMT), 3 queries are performed to find that user's activity. By configuration, 1 query may be added to each page load to find the logged in user's "activity today". By configuration, 1 query may be added to each member profile view to find that member's "activity today".

The number of queries added will vary depending on a number of factors, especially enabling options which add queries and viewing posts by users who haven't been processed for the day, yet. With the default options, midday (after all users have had a post view and thus have had their activity calculated and put in the database), it should add 0 to 1 queries to each page load depending on if the logged in user posted in that page.

I provide information about the load impact of each setting in the description of the setting in the CP (if no info is provided, then there is no load impact) so you should be able to easily tune this to your board.