This is to prevent the aggregated SQL files from becoming to large.
Symphony is quite good in executing tons of SQL statements. Putting those in a single JSON file might make it a bit too large. This will cause PHP to consume too much memory when trying to read it. That is a potential problem.
The workaround is to clear the log once in a while, after creating a fresh backup which is restored to all your environments.
This is to prevent the aggregated SQL files from becoming to large. Symphony is quite good in executing tons of SQL statements. Putting those in a single JSON file might make it a bit too large. This will cause PHP to consume too much memory when trying to read it. That is a potential problem.
The workaround is to clear the log once in a while, after creating a fresh backup which is restored to all your environments.