nice hack ill post a hack based of your query for forumhome.

Sure, go ahead. Mentioning me & Logician would be cool, though. And a link to this hack? :)

hmm, your profile page loads quite slow...

yes you are right here, that part should be relativ fast
but for getting the global percentage you need also that query:
which will become slower and slower how more posts you have.
ok, getprofile isn't called so often, but also there i don't think that's such a good way.
i'd use a sort of caching the absulote letter ammount and just update it rarely :)

I'd hate having to do that manually by loading up a script, and I don't have access to the crontab task scheduler, so I prefer doing it dynamically. :)

Yep, my profile pages load quite slow, mostly because this is just a small part of a shared server and really underpowered. The letter statistics do not account for a major part of the generation time, though. Granted, that's because there are some other modifications in there.

Overall, I think it's the best way to do it in a case similar to mine.

:) you can do it 'nearly' dynamically without having acces to a crontab scheduler :)

but i'll leave it up to you ;)

just as a hint, look at the cached birthdays on forumhome ;)

Alright, gonna do that. ;)

I also want to look at your forumhome optimization hack on the weekend, caching the moderators sounds like a nice idea.

thx :)

i currently have a chaching hype ;)

https://vborg.vbsupport.ru/showthrea...297#post369297

i'm sure it can help you, too from what i know :)

Nice hack! installe whas super easy, works great, tnx!