Change the way the character saves.

[yazar8 584]

I found a pristine green balaclava, I put it in my backpack, the server restarts.

 

When I'm back I see I don't have the balaclava anymore. It's really annoying. The character should be saved more frequently.

 

To start the nerd talk here, I also know programming a little, I know the stats save around each 45 - 60 seconds.

 

I know the query which updates a character stats is atleast divided to a few queries and updating atleast 250 rows once at a time. It can be even more.

 

That's actually a lot and considering the main database being spammed constantly with new queries of players joining, UPDATE'ing, SELECT'ing, fetching, bla bla bla bla, the SQL server should be very busy. But at a game like DayZ you can loot 5 different items at a minute and if those are not saved then you lose it all.

 

The stats should be saved more frequently.

 

My idea is, either save the item that has been taken out / added as soon as the item has given an update to the game, or save the stats every 5 seconds, which would cause an overload though, 40 players on one server would mean 40 update queries and a minute 480 total (considering all that thing was sent at one query) and that would cause an overload, in my opinion.

 

So It would be better if we got it updated as soon as we take or leave the item.

Edited October 8, 2014 by Yazar8

[Tegla (DayZ) 112]

My idea is, either save the item that has been taken out / added as soon as the item has given an update to the game

 

This would crash the server so fast

[Baker. 1484]

I found a pristine green balaclava, I put it in my backpack, the server restarts.

 

When I'm back I see I don't have the balaclava anymore. It's really annoying. The character should be saved more frequently.

 

To start the nerd talk here, I also know programming a little, I know the stats save around each 45 - 60 seconds.

 

I know the query which updates a character stats is atleast divided to a few queries and updating atleast 250 rows once at a time. It can be even more.

 

That's actually a lot and considering the main database being spammed constantly with new queries of players joining, UPDATE'ing, SELECT'ing, fetching, bla bla bla bla, the SQL server should be very busy. But at a game like DayZ you can loot 5 different items at a minute and if those are not saved then you lose it all.

 

The stats should be saved more frequently.

 

My idea is, either save the item that has been taken out / added as soon as the item has given an update to the game, or save the stats every 5 seconds, which would cause an overload though, 40 players on one server would mean 40 update queries and a minute 480 total (considering all that thing was sent at one query) and that would cause an overload, in my opinion.

 

So It would be better if we got it updated as soon as we take or leave the item.

There is a lot of information being written to the database in this game. Combine that with all the other networked events and I"m surprised they manage to write as often as they do. More saves equals exponentially more network traffic and when using a shared Hive this would not only affect the game server but the poor mysql DB as well.