In the absence of a long wipe and numerous harvests from the claim, the number of records in the database per one cell grows by 5 records (young sowing, mature, ripe, soil, fertile soil) for each harvest.
If we calculate that from a field of 400 cells with 10 harvests, the base will increase 400 * 10 * 5 = 20,000 records.
And this is only one claim.
I have a 1.2Gb database on my server
select count (*) from geo_patch = 17862086;
select count (*) from geo_patch where (substance> 100) = 1322917;
Field substances begin with id = 101;
1322917 * 5/3 = 2204861 - extra harvest records.
The suggestion is to delete these entries except for the latest version on the field, since the field height does not actually change. If the field was buried after harvest, then the actual field does not change either.
Removing unnecessary records of soil changes during harvest from the database
1A practitioner will always shoot a theorist ...
P.S. Russia, Siberia
P.S. Russia, Siberia