08.06.2011, 03:56
I have a fairly large server using SQL to save most stats and I was wondering which of these following ways is better.
Load all stats into bug enums (Ex: PlayerInfo) and only update them on logout.
or
Get rid of enums like PlayerInfo completely and just load/save stats into the database whenever needed.
or
A healthy mix of both?
My server is hosted on a fairly decent VPS but I still want to make it as optimized as possible.
I'm wondering if using SQL directly would speed up things in the script because it doesn't have to load stats that are never used.
Thanks for answers in advance!
Load all stats into bug enums (Ex: PlayerInfo) and only update them on logout.
or
Get rid of enums like PlayerInfo completely and just load/save stats into the database whenever needed.
or
A healthy mix of both?
My server is hosted on a fairly decent VPS but I still want to make it as optimized as possible.
I'm wondering if using SQL directly would speed up things in the script because it doesn't have to load stats that are never used.
Thanks for answers in advance!