The table grows ActivityPointerBase grows overdimensionally fast. In the production environment, the table consumes almost 2 GB more memory than in the test environment.
The test environment was also recently copied from the production environment, which means the environments should be at about the same level.
Test environment: 2,027,453 records
14.624 MB
Production environment: 2,051,935 records
16,607 MB
Assuming the test environment, however, 1 GB of data should only come about with 2,027,453/14.6 = approx. 140,000 more data records.
While according to the current state even 2 GB more is used for only 24,482 records.
Even more curious is the case that only 2,700 records have been added recently and for that about 1 GB of storage space has been added.
Why is the table growing so much in memory even though so few new records have been added?
