StrangeLoopGames / EcoIssues

131 stars 21 forks source link

Add activity log to all relevant objects, etc #19927

Open johnkslg opened 3 years ago

johnkslg commented 3 years ago

image

Create a design doc for how this will work first and get it approved.

IcedForge commented 3 years ago

We have store logs up to 100 last transactions, maybe this list can be expanded on? but im worried about DB size bloating if everything is tracked. For example mishkas server has been running for 120 days almost now and his backup sizes are over 6gb each. This amount of data across 100's of players is 100.000 entries per day at least how will this effect DB's and overall performance?

IcedForge commented 3 years ago

To get some perspective to this. On an average public server ( not official that tend to amass more players ) You are looking at 30-100.000 items crafted per hour on average. Economy trades seems to float around 200-800 per hour depending on server economy collaboration( if people are playing more of a communion or if its a free market situation ).

When you have larger servers this is expanding quite rapidly with 100-300k items crafted and 1000-2000 items trades per hour.