#Caching issues with a core
1 messages · Page 1 of 1 (latest)
cache online players only?
no, offline friends
why do you need it cached?
so their names, prefixes and suffixes show in the friend list
yes, cache all friends of the online players
isn't that going to cause alot of performance issues
no
better than querying it all the time
i understand this part lol
computers are fast and have lots of memory 🙂
only performance thing I could see is the read/write speed of SQLite, no idea of what that is
querying all the time is not the bad design, although. In some cases, storing data almost in database is helpful
yeah, use something scalable like mariadb or postgre
so an interface with the data i need is fair enough (only prefix, suffix and name) and then just remove on player leave?
and probably update them on special cases
Could just store the entire player object, I doubt its much bigger
it kinda is much bigger tbh
Or just don't bother including prefix/suffix, just have the name and some indentation of if they are online or not
as that would be much better on performance
well that's a feature that i need to add :)
Either way then, you got your answer above