topic Re: Survey 123 database storage in ArcGIS Survey123 Questions

Survey 123 database storage

AnnaBarca1 — Fri, 01 Aug 2025 01:03:32 GMT

I have a survey 123 that was using 900 + MB. I have deleted half of the records, including photo attachments, and points from the _results and _form feature service.

Those records are not there anymore, however the size of my database hasn't change.

Can anyone tell me why and how to fix this ?

Re: Survey 123 database storage

ChristopherCounsell — Fri, 01 Aug 2025 07:26:08 GMT

https://doc.arcgis.com/en/arcgis-online/manage-data/manage-hosted-feature-layers.htm#ESRI_SECTION1_030A9819DFF7498E9DFCDE6030E5FFBA

When you enable the options Enable sync (required for offline use and collaboration) or Keep track of changes to the data (add, update, delete features) on your hosted feature layer or hosted table, ArcGIS Online stores information about data changes and offline versions in a change log. This change log grows as changes continue to accumulate. To avoid credit charges associated with a large change log, you can trim it.

There are backend tables for Sync and the 'Keep track of changes to the data' that can grow considerably over time or high volumes of editing.

Toggling sync on/off will remove any replicas (and any offline edits yes to be synced! so use wisely!).

Turning off the change tracking or trimming it will reduce its size. The change log is NOT the same as keeping track of who last made changes to the data (the CreationDate, EditedDate fields etc). It's a table that tracksadds/updates/delete requests and is designed to be used for things like service based webhooks or other change detection.

Re: Survey 123 database storage

DougBrowning — Fri, 01 Aug 2025 13:01:17 GMT

I run a script to give me a list of replicas and a script to remove old ones as Field Maps does not remove them if you remove an area while offline.

I was actually not sure but AGOL hosted does have a way to compress also.

See this post https://community.esri.com/t5/arcgis-online-questions/reduction-of-space-and-credit-consumption/td-p/1392412

But basically go into the Rest page for the service, then admin on the top right, then compress at the bottom.

I strangely do not think I have ever done this. We only add and do not delete but we do remove old replicas so I wonder.

Anyone have more info on this or have scripted it somehow?

Re: Survey 123 database storage

AnnaBarca1 — Fri, 08 Aug 2025 01:32:27 GMT

Thank you Christopher,

So if I un tick sync all my additional data should go and the usage would only show what's current, right ?

Re: Survey 123 database storage

ChristopherCounsell — Fri, 08 Aug 2025 12:37:03 GMT

You may need to turn off the editor change tracking as well or trim logs.

It may take a moment to update.