I'm using smartfox to develop a game with big data, might this game will have 4-5 billion records in some of table in database.
I don't want to call query when game's running, that will make the game has delay time.
My solution:
I will load all data from database then store in RAM in ZoneExtension when starting server.
Something like this:
Code: Select all
private Map<Long, MyEntity> myData = new ConcurrentHashMap<Long, MyEntity>();
private Map<Long, MyEntity1> myData1 = new ConcurrentHashMap<Long, MyEntity1>();
....
And using these Map to have the needed data when game running.
Right now, It works well for me on my dev environment with small database, but i wonder that when these map size be increased to 4 or 5 billion, even more-> Is it still work well?
If you have experience in same this issue please share me.
Thanks alot