I'm looking for a place where I can host a database(no website needed) to mimic a leaderboard for a game I'm making. I've already set it up on x10hosting and everything works wonderfully, but that's with testing. I'm wondering if I might reach some limits once the game gets popular
The game could potentially reach something like this: 600 users making a simplish SQL request on the database and the PHP returning a JSON string of ~15,000 characters(not returning the whole leaderboard just sections). All of this maybe twice a minute per user on average at peak time for the game.
However the user may also choose to download a string I have in a SQL cell that could be 50K-130K long(occasionally longer). This I would imagine each user doing once a minute.
Each row in the database would have about 9 columns, each cell being fairly short(5-12 characters) except for that one cell that may be 50k-130k long. I'm predicting after a year I may have 100k-200k of these rows.
All of this is the highest traffic I am predicting after a year, it could very well be less than this. Assuming I had a premium account, does all of this sound reasonable, particularly in data size and resource/bandwith use? I'd hate to be suspended and have to find a new host.
The game could potentially reach something like this: 600 users making a simplish SQL request on the database and the PHP returning a JSON string of ~15,000 characters(not returning the whole leaderboard just sections). All of this maybe twice a minute per user on average at peak time for the game.
However the user may also choose to download a string I have in a SQL cell that could be 50K-130K long(occasionally longer). This I would imagine each user doing once a minute.
Each row in the database would have about 9 columns, each cell being fairly short(5-12 characters) except for that one cell that may be 50k-130k long. I'm predicting after a year I may have 100k-200k of these rows.
All of this is the highest traffic I am predicting after a year, it could very well be less than this. Assuming I had a premium account, does all of this sound reasonable, particularly in data size and resource/bandwith use? I'd hate to be suspended and have to find a new host.