DDraceNetwork

deen

I just noticed that our script for the website calculation has become quite a bit slower as well, takes over 1 hour to update the ranks pages now. Used to be ~20 minutes a year ago. Good problem to have so many ranks now

This sounds rather long, should we look into some caching and pagination?

LeaRATh2

hepl i found some bug, sometimes hook on other players is weaker than normal

4

06:12

remove it pls? EC_Shy

2

louis

hepl i found some bug, sometimes hook on other players is weaker than normal

Thats not a bug tho but a feature. There is an yt channel that explains it (edited)

@Learath2 pagination doesn't help. the sql queries would have to be optimized

07:58

and creating /ranks/ is exactly the caching stage

deen

@Learath2 pagination doesn't help. the sql queries would have to be optimized

Could a timestamp be added such as a Last Updated. That way you don't need to re-calculate from the beginning of time but only since previous execution.

i can't connect my dummy

deen

and creating /ranks/ is exactly the caching stage

I meant as in caching older pages of ranks, e.g only generating whats new/changed

well, people make ranks so quickly especially on novice, and novice is the expensive one to create

17:31

even the regular mysql caching doesn't help much when you get a new rank on Multeasymap every few seconds

17:31

@Zodiac makes it so complicated and stateful. It's really not a problem to take > 1 hour, just switch to another faster server soon and optimize the sql queries a bit and it'll be good for a few more years

1

deen

@Zodiac makes it so complicated and stateful. It's really not a problem to take > 1 hour, just switch to another faster server soon and optimize the sql queries a bit and it'll be good for a few more years

Good point - rather avoid that if possible

louis

hepl i found some bug, sometimes hook on other players is weaker than normal

ye i experienced that too

18:28

when fix