Achievements System in PHP [closed]

-1

I am developing an application of achievements / feats / insignias in PHP.

The application will be for a game in which it uses a SQL Server database and server files in a Cloud, however I can not make changes to the game so it is updated in real time.

If I were to upgrade to CronJob and there were more than 30,000 users in the database, would it be feasible?

An example of what I'm developing: steamcommunity

    
asked by anonymous 02.04.2014 / 10:00

1 answer

1

This is very relative and will depend on the flow of users and the tables involved.

If there is no way to modify the game script to save the data as the user advances, then I only see cronjob as a solution.

You have to analyze the following:

  • What is the optimal time to run cronjob, that is, with less stream of users?
  • If the flow is large at all times, does your server handle all processing?
  • Does your script update the database, it consumes a lot of memory?

With the answer in hand, you will know:

  • If your architecture is the best choice. Maybe it's an exaggeration, but it would not be better to move to a distributed database;
  • If your server needs an upgrade and if that solution is enough;
  • If your script (which updates the database) needs to be optimized;
  • Whether the database needs to be optimized.

As you can see, if you do not want to affect the performance of the application, you have to be careful and not just to do a cron job, but only you who know the system can respond.

    
02.04.2014 / 11:39