Data File Size and Response Times

Will's Avatar

Will

14 Jun, 2024 12:02 AM

The response times in MD are slowing down. It has become noticeable in the last few months. Is anyone else experiencing this? My data file is over 150MB. Can anything be done about this? I need to keep all my data in the file, so archiving older data is not an option.

Thanks..

  1. 1 Posted by dtd on 14 Jun, 2024 02:45 AM

    dtd's Avatar

    Use Toolbox, Shrink Database as a start.

  2. 2 Posted by dtd on 14 Jun, 2024 02:45 AM

    dtd's Avatar

    What version of MD are you using and what OS?

  3. 3 Posted by Stuart Beesley ... on 14 Jun, 2024 05:55 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    After running shrink dataset, use toolbox, analyse dataset and objects and upload that output here. Also grab help/console and upload that here too.

  4. Support Staff 4 Posted by Maddy on 14 Jun, 2024 08:46 AM

    Maddy's Avatar

    Hi Will,
    Thank you for contacting Moneydance support.

    Generally, delays in opening or closing/backing up your data file are usually due to either your data file or the backup location from the preferences being located in a shared folder.
    So, you may want to ensure that your data file is stored in the default location, to start with.

    Additionally, since you own a license of Moneydance 2023, you could install Moneydance 2024.2 (5134). This is now available to download from this page.

    For a full list of improvements in the preview version, please refer to this page.

    We recommend overwriting or manually removing the older version.


    In order to decrease your data set size, you could navigate to Extensions->Manage Extensions and install the Toolbox (version 1065).

    • Launch the Toolbox and select Updated mode (at the top).

    • Click on MENU: Advance Options and choose: Shrink Dataset size. Set it to 1 day.

    You should then carefully follow the on-screen instruction, allowing the disclaimer and restarting Moneydance once the process is complete.

    Please keep us posted on your progress, Thank you!

    --
    Maddy, Infinite Kind Support

  5. 5 Posted by Will on 14 Jun, 2024 02:51 PM

    Will's Avatar

    Using Sonoma 14.5
    Using MD 2024.2

    Shrink done. Before and after output attached. I think I have uploaded everything asked for. I will try MD for a week or so and see what difference shrinking makes.

    Appreciate the prompt response from all, thank you..

  6. Support Staff 6 Posted by Maddy on 14 Jun, 2024 03:01 PM

    Maddy's Avatar

    Unfortunately, we are aware of an issue with Sonoma and iCloud Drive Sync that causes some slowness, Will.
    I believe this is what might causing the issue in your case.

    So, we recommend disabling iCloud Drive sync or switching to a different sync method.

    To achieve this, from your computer/s:

    • Launch Moneydance and navigate to File->Syncing
    • Choose 'Don't Sync' and close Moneydance.

    • Set up sync again as outlined in these articles:

    "Syncing with Other Computers" here

    "Syncing with Mobile App" here

    --
    Maddy, Infinite Kind Support

  7. 7 Posted by Will on 14 Jun, 2024 03:16 PM

    Will's Avatar

    This comment was split into a new discussion: Security Price Entry extension

    You may be right, Maddy. The inebriation only started in the last year or so and I only started syncing in that time period. I want to be able to sync (I am not willing to use any site other than Apple/iCloud), but it not a need, so if it continues like it has over the next week or so I will disable syncing.

    Separate question: On Security Price Entry extension, is it possible to only list active stocks/bonds? I do a manual update every Friday and month-end, since to auto-updates don't work for me at Yahoo, etc., and I don't have an API. I can post as a new query if you wish.

    Thanks..

  8. Support Staff 8 Posted by Maddy on 14 Jun, 2024 03:30 PM

    Maddy's Avatar

    Thank you for your feedback, Will!

    I split your last query to a separate thread as it concerns a different topic.

    I'd close this discussion for now, but please don't hesitate to get back in touch, if you need further assistance.

    --
    Maddy, Infinite Kind Support

  9. Maddy closed this discussion on 14 Jun, 2024 03:30 PM.

  10. Stuart Beesley (Mr Toolbox) re-opened this discussion on 14 Jun, 2024 04:01 PM

  11. 9 Posted by Stuart Beesley ... on 14 Jun, 2024 04:01 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Shrink reduced your dataset from 160MB to 67MB. Not bad!!
    Toolbox 🧰 +1 😃

    Please grab help/show console and upload that here.

  12. 10 Posted by Will on 14 Jun, 2024 07:39 PM

    Will's Avatar

    Agreed. I think the attached is what you are looking for. I am assuming nothing proprietary is in this files I am uploading without hesitation! :)

  13. 11 Posted by Stuart Beesley ... on 14 Jun, 2024 08:46 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Nothing obvious in the log. So I suspect iCloud Sync. Is speed better when sync off.

    There are a lot of outdated extensions, so I would update all and delete the rest…

  14. 12 Posted by Will on 14 Jun, 2024 09:01 PM

    Will's Avatar

    I noticed that, too. Alas, the only Extensions I have installed are
    MoneyPie, Security Price Entry, Stock Glance and Toolbox.

    I was going to give the update I did a week before I disable sync. Will
    let you know.

    Thanks..

    wjw

    __________________________________
    Sent from eM Client | www.emclient.com <https://www.emclient.com/get>

    On 6/14/24, 3:46:40 PM, "Stuart Beesley (Mr Toolbox)"
    <[email blocked]> wrote:

  15. 13 Posted by Homer712 on 14 Jun, 2024 09:04 PM

    Homer712's Avatar

    Stuart, I always learn new things just reading through some of these issues that others are having. This whole "shrink" is a case in point. I have two installations of Moneydance (both Mac systems and running MD 2023.3) and sync via Dropbox. My data set is only 30.9 MB on both systems.

    Question: When one does the "shrink" thing, does it need to be done on both systems, or do you do it on one and then the "sync" takes care of the second system?

  16. 14 Posted by Stuart Beesley ... on 14 Jun, 2024 09:23 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    You can do shrink on either copy, or both. The ‘shrink’ does not replicate.

  17. 15 Posted by Homer712 on 15 Jun, 2024 01:39 AM

    Homer712's Avatar

    Followed Maddy's instructions in Post #4 and ended up shrinking the data set from 30.9 MB down to 8.9 MB. At first I was surprised, but then I've been using Moneydance since 2007 and have never performed a shrinking of the data set, so maybe that reduction is pretty normal.

  18. 16 Posted by dtd on 15 Jun, 2024 02:28 AM

    dtd's Avatar

    I've done a shrink a few times - it normally goes from about 150mb to 87mb (40 years of data and lots of stock histories).... it does begin to grow again, so I do this 2-3 times per year.

  19. 17 Posted by Stuart Beesley ... on 15 Jun, 2024 05:58 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Toolbox 🧰 +1 😃

  20. 18 Posted by Homer712 on 15 Jun, 2024 11:55 AM

    Homer712's Avatar

    The Toolbox menu (at least mine) has additional items listed (see screenshot). Is this by design? I think I understand the first two, but the last one I really can't figure out.

  21. 19 Posted by dwg on 15 Jun, 2024 12:07 PM

    dwg's Avatar

    The extra items are intentional, they are standalone, although part of the suite.

    The Zap one deletes the contents of downloaded memo fields,

  22. 20 Posted by Homer712 on 15 Jun, 2024 12:27 PM

    Homer712's Avatar

    Thank you!

  23. 21 Posted by Will on 16 Jun, 2024 03:14 PM

    Will's Avatar

    So, it became clear that the update to the current version didn't work. I disabled Sync and the experience is much smoother. I hope we get to a point where syncing in iCloud runs smoothly; I like the feature.

    Thanks, again, to all who helped on this.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac