topic Re: Replica size growth in .NET Maps SDK Questions

Replica size growth

JoeHershman — Wed, 07 Dec 2022 14:36:44 GMT

Hi,

There may be a better place to post this, but not sure where

We have an app that has been in the field for a while (few years). What we are seeing is unexplained growth in the replicas which does not match the amount of data being added. There are replicas growing to almost a GB in size, but if we regenerated the replica (so has the same number of records) it is about 1/3 that size.

Would love to understand why this occurs, and looking from a solution that could compress these down so we do not have to push new replicas (this is deployed to close to 1000 devices)

Thanks - joe

Re: Replica size growth

MichaelBranscomb — Wed, 07 Dec 2022 21:17:29 GMT

Hi Joe,

Do you mean the replicas themselves have been in the field on devices for a few years and are growing incrementally after synchronizing?

Thanks

Re: Replica size growth

MichaelBranscomb — Mon, 12 Dec 2022 03:36:52 GMT

@joe A couple of options to consider:

On the replica mobile geodatabase itself, you can try running the SQLite vacuum command (e.g. via a SQLite .NET NuGet package or via a SQLite database browser tool)
On the Enterprise geodatabase side you could try running the Trim Archive History GP tool.

Re: Replica size growth

JoeHershman — Mon, 12 Dec 2022 16:13:39 GMT

Sorry slow replying

Yes this is for replicas that have been deployed since the original deployment, so a couple years+ and have just been growing over time
I was looking at the sqllite vaccum command and just need to find some better info on exactly how to run on the db, but not as part of a update or insert statement
- The easiest thing would be if we could setup something that could run on a periodic basis, maybe at app startup. Pushing an updated application is the simplest process in place