nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey 123 database storage

AnnaBarca1

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 ?

Find more posts tagged with

Accepted answers

AnnaBarca1

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 ?

All comments

ChristopherCounsell

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

It may take a moment to update.

AnnaBarca1

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 ?

dougbrowning

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?

ChristopherCounsell

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.