deleting prices history

Blair's Avatar

Blair

02 Jul, 2021 07:44 PM

Are there any routines out there that will go through each security and delete a large chunk of price history? The idea is to condense the size of the data file and reduce load time.

  1. 1 Posted by Dan P on 02 Jul, 2021 08:15 PM

    Dan P's Avatar

    (Just another user here)

    Try Stuart Beesley's Toolbox. You can install it from the Manage Extensions menu.
    It has an option to do thinning and purging of securities. You can run it without deleting anything to see if you get what you want.

    ALWAYS DO A BACKUP!

  2. 2 Posted by Stuart Beesley ... on 02 Jul, 2021 08:37 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    As DanP says, toolbox can do this for you. 

    However, I doubt this is the cause of of your large dataset and slow load time. Are you on MD2021.1? Also in Toolbox is a button to analyse your dataset objs and size. Might be useful to run that and post the results here.

  3. 3 Posted by Blair on 03 Jul, 2021 03:19 PM

    Blair's Avatar

    Hi Stuart.

    Thanks for your reply. I am on that version (3069). From data analysis:

    DATABASE OBJECT COUNT (count) (est.size KBs):
    -----------------------------------------------------
    Object: mem_rpt 10 13.9
    Object: csnap 7594 1696.9
    Object: reminder 2 1.1
    Object: secsubtypes 1 0.4
    Object: olpmts 1 9.6 (containing 24 Online
    Payments)
    Object: txn 8507 6461.4
    Object: olsvc 5 15.8
    Object: csplit 1 0.2
    Object: oltxns 70 2865.1 (containing 3558 Online
    Txns consuming 2741.2 KBs)
    Object: olpayees 1 29.8 (containing 99 Online
    Payees)
    Object: curr 161 47.6
    Object: acct 374 102.8
     ==========

    This is after running the thin purge.

  4. 4 Posted by Stuart Beesley ... on 03 Jul, 2021 03:29 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    Yup, your objects are tiny...

    I really need to see the report including the lines above the ones you sent. The first section details your file sizes etc.... And the TOTAL line after the bit you sent too....

    Also, FYI - I note: Object: oltxns 70 2865.1 (containing 3558 Online Txns consuming 2741.2 KBs).. These are cached downloaded txns and the cache should be empty. After a backup you can run Toolbox>Online Banking Tools>View your online Txns report and then if you like the Delete All Cached OnlineTxnList Records option.

    (not support, just a fellow user)

  5. 5 Posted by Blair on 03 Jul, 2021 05:08 PM

    Blair's Avatar

    Dataset path: C:\Users\blair\.moneydance\Documents\Blair.moneydance

    Dataset size: 24.6MB
    - settings file size: 25.6KB
    - key file size: 0.1KB
    - tiksync folder size: 23.9MB (with 24 files)
      (note trunk file size: 11.8MB)
    - attachments size: 0.0MB (in 0 attachments)
    - archive size: 0.6MB (in 2 files)
    ---------------------------------------------
    Valid files size: 24.6MB (in 28 files)

    Non-core file(s) size: 0.0MB (in 4 files)
       - Non-core: 0.0MB
    C:\Users\blair\.moneydance\Documents\Blair.moneydance\investment_reports_error0.xml
       - Non-core: 0.0MB
    C:\Users\blair\.moneydance\Documents\Blair.moneydance\MRBPreferences.dict2
       - Non-core: 0.0MB
    C:\Users\blair\.moneydance\Documents\Blair.moneydance\securityquoteload.bpam2
       - Non-core: 0.0MB
    C:\Users\blair\.moneydance\Documents\Blair.moneydance\safe\tiksync\uploadbuf

    LARGE (core) file(s) > 0.5MB....:
       - 0.5MB Mod: 2021-06-01
     C:\Users\blair\.moneydance\Documents\Blair.moneydance\safe\archive\202104.mdtxnarchive
       - 11.8MB Mod: 2021-07-03
     C:\Users\blair\.moneydance\Documents\Blair.moneydance\safe\tiksync\trunk
       - 11.8MB Mod: 2021-07-02
     C:\Users\blair\.moneydance\Documents\Blair.moneydance\safe\tiksync\in\trunk-202107021103.mdtxn

  6. 6 Posted by Stuart Beesley ... on 03 Jul, 2021 05:17 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    OK, your whole dataset is tiny and very clean. The only file that you could consider deleting is:

    C:\Users\blair\.moneydance\Documents\Blair.moneydance\safe\archive\202104.mdtxnarchive (11.8MB) - but I wouldn't bother.
    

    You also only have a few files, and a few objects... So there is nothing to make your MD load time slow.

    So, can you clarify what you mean by slow load time?

    Perhaps post your console output (Menu, Help, Console Window)..

    (not support, just a fellow user)

  7. System closed this discussion on 02 Oct, 2021 05:20 PM.

Comments are currently closed for this discussion. You can start a new one.

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