we got a script of a. game based on php ,
it stores tasks in mysql with type and end time .
if end time = now
then it will auto execute the task
when the number of tasks is less than a 100 at one time , then everything works fine without any issues
but when we got over 100 tasks at one time , then the system start bugging and instead of finishing all of them at once , then it starts to work one by one which makes it delay the tasks execution
if player A starts 100 task , then player B start 10
the player B has to wait for player A tasks to be done , which is not correct it supposed to finish any task once its time achieved