I need help deciding what method would be best suited for my open world game. I have two thoughts about how to read variable data for the Monsters. Basic question is would it be a better practice to read variables from the monsters object using the built in variable system or should I create a database via MySQL? What would be the Benifind and what would be the risks of each?
So far I am leaning more and more to the MySQL database for several factors. First and foremost is the ability to patch the game at a later time should the need arise. Rather then having to manipulate every creature in the game one by one you can use a database that is on the server (Read Only Access) and patch it by modifying the data table on the server. The second key thing to note is that MySQL being on a sever rather then in the game would free up memory and the game will be a smaller file without all the data in the game itself. Lastly with MySQL I could hook it up to a website where you can use the search feature and display stats allowing for a search feature and staying organized.
So the main question here is thier any huge advantage to using the UE4 system to store variables? Just wanna make sure I am not missing something as with the scale of the game it’s a ton of data if I screwed up.