#Caching issues with a core

1 messages · Page 1 of 1 (latest)

sinful escarp
#

:3

candid geyser
#

cache online players only?

sinful escarp
#

no, offline friends

devout scroll
#

why do you need it cached?

sinful escarp
#

so their names, prefixes and suffixes show in the friend list

candid geyser
#

yes, cache all friends of the online players

sinful escarp
#

isn't that going to cause alot of performance issues

lean briar
#

no

devout scroll
#

better than querying it all the time

sinful escarp
#

i understand this part lol

candid geyser
#

computers are fast and have lots of memory 🙂

devout scroll
#

only performance thing I could see is the read/write speed of SQLite, no idea of what that is

lean briar
#

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

sinful escarp
#

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

devout scroll
#

Could just store the entire player object, I doubt its much bigger

sinful escarp
#

it kinda is much bigger tbh

devout scroll
#

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

sinful escarp
devout scroll
#

Either way then, you got your answer above