I am trying to update the database of an e commerce website with a php cron script in linux server.The cron is update products in a table where the number of products are around 1200000.The problem is cron is taking almost one day to complete the cron sript,which is very much.
Please tell me the points on how can i reduce the cron script updation time to 2-3 hours or less than that.
Database- Mysql Language-Php Server-Linux