I see there are new cleanup tools for the database, which is very nice.
Apart from skill raise logs table, the geo_patch is by far the biggest table in the database. I think it's working the same way as the other patch tables.. it store all history without ever deleting anything.
Is it possible to clean it too?
Re: Possible to clean up geo_patch table?
2It's possible, yes. But there are two reasons why I didn't implement it:
1) On Custom Maps, any changes to the geo_patch history means that the server admin has to go through the full setup procedure again. So there will be several hours of downtime. I'm not sure it's worth the effort (for them).
2) The game never reads anything from geo_patch during runtime. It reads from that table on server startup only, during terrain initialization. So optimizing that table would have no impact on performance. Maybe on boot up duration, a little...
1) On Custom Maps, any changes to the geo_patch history means that the server admin has to go through the full setup procedure again. So there will be several hours of downtime. I'm not sure it's worth the effort (for them).
2) The game never reads anything from geo_patch during runtime. It reads from that table on server startup only, during terrain initialization. So optimizing that table would have no impact on performance. Maybe on boot up duration, a little...
