[WetWired]

<a href="https://vborg.vbsupport.ru/showthread.php?t=73145" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=73145</a>
I'm trying to optimize this hack, as it seems the only replies I get are "too many queries". I could make it add only two queries per page by calculating activity every page load, but those would be big expensive queries, and I believe my current approach of doing the work once a day is better, but I can't get past the fact that it requires a query to store each result.

Right now, the first time a user's post is encountered on a given day, it does a query for the number of posts by the user for each of the x past days, and a query for the number of days visited out of the x past days, does some math, then does a query to store the dated result. The result is also cached so if the same user's post is encountered again on the same page, the calculation is not repeated.

Also, I'm considering adding a day field to each post to avoid doing math on dateline to determine the day for grouping, but I'm wondering if the performence enhancement is worth the extra hacking (not to mention the compatibility problems this may cause with other hacks that generate posts).