At my current employer a PHP script was used that extracts entries from a large database table, optimizes them and saves them in a second table.
This script was written years ago and it ran every day for 12 hours. Although the general rule "never change a running system&