tag:infinitekind.tenderapp.com,2009-01-14:/discussions/iphone-ipod-touch-ipad-android-app-questions/17191-reducing-file-sizeInfinite Kind: Discussion 2023-05-28T23:35:58Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/590484122023-05-27T08:55:04Z2023-05-27T08:55:04ZREDUCING FILE SIZE<div><p>You can’t. But file size is not normally a problem for MD. Do you actually have a size/speed issue?</p>
<p>There are some tricks tho’.</p>
<p>Do this, install/run toolbox extension. Click ‘analyse dataset and objects’ button. Post the output here.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/590484122023-05-27T09:00:56Z2023-05-27T09:00:56ZREDUCING FILE SIZE<div><p>I'm a fellow user.</p>
<p>The archiving feature was removed in one of the Moneydance 2015 releases. It was found to be particularly problematic especially where Investment accounts were involved where you cannot arbitrarily archive before a certain date since those investments can still be active. You cannot just exclude investment accounts either since they often involve transfers between accounts and with Moneydance being built on double entry accounting principles if you remove one side of the transaction you must remove the other side.</p>
<p>Many people think that archiving old data will improve performance, experience has shown that this is not the case with modern computer systems. Trying to reduce the storage used i.e. reduce file sizes, is also an often stated aim. Because of data integrity we know this is not a good idea, however it is suggested to use the Toolbox extension which can remove redundant data and can also perform tasks like pruning old share price data and thus reduce file sizes without the loss of user level data.</p>
<p>In general it is recommended to use the filters provided in Moneydance to limit the amount of data viewed and to use reports with date ranges if you want to see specific data. Views or in Moneydance terms Filters are the way that Databases restrict the amount of data showing without removing data since once removed it is no longer usable in any way.</p>
<p>For no longer used accounts you can also mark them as inactive and remove remove them from displays and various drop downs, so the data is still there but you are not seeing it.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/590484122023-05-27T13:05:14Z2023-05-27T13:05:14ZREDUCING FILE SIZE<div><p>Many thanks. So perhaps I am looking for problems which aren’t in fact problems?</p>
<p>On balance, I am going to go with not fixing something which isn’t broken!</p>
<p>All the best.</p>
<p>JAB</p></div>Jeremy Astill-Browntag:infinitekind.tenderapp.com,2009-01-14:Comment/590484122023-05-27T13:08:10Z2023-05-27T13:08:11ZREDUCING FILE SIZE<div><p>I am sort of the view that I am looking for a problem which I don’t have, so am inclined not to fix something which isn’t broken! But see below as requested. If no obvious problem, I will let this lie. All the best. JAB</p>
<h1><a name="dataset-file-analysis-" class="anchor" href="#dataset-file-analysis-"></a>DATASET FILE ANALYSIS</h1>
<p>Dataset path: /Users/jeremyastill-brown1/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Jeremy Astill-Brown-20210813-2046.moneydance</p>
<p>Dataset size: 6.2MB<br>
- settings file size: 3.0KB - key file size: 0.1KB - tiksync folder size: 3.4MB (with 128 files) (note trunk file size: 2.8MB) - attachments size: 0.0MB (in 0 attachments)</p>
<h2><a name="-archive-size-2-8mb-in-17-files-" class="anchor" href="#-archive-size-2-8mb-in-17-files-"></a>- archive size: 2.8MB (in 17 files)</h2>
<p>Valid files size: 6.2MB (in 147 files)</p>
<p>Non-core file(s) size: 0.0MB (in 0 files)</p>
<p>LARGE (core) file(s) > 0.5MB....:<br>
- 1.0MB Mod: 2022-07-11 /Users/jeremyastill-brown1/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Jeremy Astill-Brown-20210813-2046.moneydance/safe/archive/202205.mdtxnarchive - 0.8MB Mod: 2021-10-27 /Users/jeremyastill-brown1/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Jeremy Astill-Brown-20210813-2046.moneydance/safe/archive/202108.mdtxnarchive - 2.8MB Mod: 2023-05-27 /Users/jeremyastill-brown1/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Jeremy Astill-Brown-20210813-2046.moneydance/safe/tiksync/trunk</p>
<h2><a name="database-object-count-count-est-size-kbs-" class="anchor" href="#database-object-count-count-est-size-kbs-"></a>DATABASE OBJECT COUNT (count) (est.size KBs):</h2>
<p>Object: csnap 13 2.8<br>
Object: reminder 20 14.5<br>
Object: secsubtypes 1 0.2<br>
Object: txn 5383 2691.6<br>
Object: olsvc 1 0.1<br>
Object: oltxns 15 1.3<br>
Object: curr 47 14.6<br>
Object: acct 77 28.0<br>
Object: misc 2 0.2<br>
========== TOTAL: 5559 2753.4</p>
<h2><a name="quick-search-for-other-datasets-" class="anchor" href="#quick-search-for-other-datasets-"></a>QUICK SEARCH FOR OTHER DATASETS:</h2>
<p>Dataset: Mod: 2019-11-22 /Users/jeremyastill-brown1/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Emilia.moneydance<br>
Dataset: Mod: 2021-08-13 /Users/jeremyastill-brown1/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Jeremy Astill-Brown.moneydance<br>
Dataset: Mod: 2017-10-02 /Users/jeremyastill-brown1/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Personal Finances.moneydance</p>
<h2><a name="backup-files-" class="anchor" href="#backup-files-"></a>BACKUP FILES</h2>
<h2><a name="sync-folders-found-" class="anchor" href="#sync-folders-found-"></a>SYNC FOLDERS FOUND:</h2>
<p>Sync Folder: 2023-05-09 /Users/jeremyastill-brown1/Library/CloudStorage/Dropbox/.moneydancesync/d9911341-831b-42c7-a6d9-3472d715f760</p>
<p>(for a more extensive search please use Toolbox - Find my Datasets and Backups button</p></div>Jeremy Astill-Browntag:infinitekind.tenderapp.com,2009-01-14:Comment/590484122023-05-27T13:49:07Z2023-05-27T13:49:07ZREDUCING FILE SIZE<div><p>6MB and 128 files. You have no problem to worry about.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/590484122023-05-27T15:44:37Z2023-05-27T15:44:37ZREDUCING FILE SIZE<div><p>Many thanks. JAB</p></div>Jeremy Astill-Brown