Select to view content in your preferred language

Survey 123 database storage

199
4
Jump to solution
a month ago
AnnaBarca1
Occasional Contributor

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 ?

0 Kudos
1 Solution

Accepted Solutions
AnnaBarca1
Occasional Contributor

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 ?

View solution in original post

0 Kudos
4 Replies
ChristopherCounsell
MVP Frequent Contributor

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

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.

DougBrowning
MVP Esteemed Contributor

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...

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?

AnnaBarca1
Occasional Contributor

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 ?

0 Kudos
ChristopherCounsell
MVP Frequent Contributor

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

It may take a moment to update.

0 Kudos