Fix mysql data updation glitch from one sql table to another (code is in corephp) having a cron job

I require assistance to fix a glitch associated with data updation of a single table in mysql. The code is written in corephp. the code is made to fetch the data from one mysql table, count the rows in that mysqltable, and put the count number in another mysqtable, however that is stuck (maybe due to large amount of data). so that needs to be fixed alongwith its cron job. It shouldn't more then 30 mins (could be much less also if its a php expert). Need to be done using anydesk/teamviewer online / live.