locked
sunriise: disk usage calculation for *.mny file RRS feed

  • General discussion

  • The next build of sunriise will have a utility to let you calculate the disk usage for each of table. That will give you some visibility into 'why my *.mny file is of size XYZ?'. Thanks to the upstream folks of Jackcess for adding the calls to make this possible.

    Sample output: not surprising, transaction table takes half of the disk usage: ~58MB (75K rows)

    C:\file.mny, 94740480, 94.7 MB

    ACCT, 263, 290816, 290.8 kB ADDR, 415, 77824, 77.8 kB ADV, 109, 32768, 32.8 kB ADV_SUM, 100, 12288, 12.3 kB Advisor Important Dates Custom Pool, 0, 16384, 16.4 kB Asset Allocation Custom Pool, 0, 16384, 16.4 kB AUTO, 2, 16384, 16.4 kB AWD, 0, 24576, 24.6 kB BGT, 7, 20480, 20.5 kB BGT_BKT, 98, 36864, 36.9 kB BGT_ITM, 1649, 499712, 499.7 kB BILL, 1657, 802816, 802.8 kB BILL_FLD, 0, 12288, 12.3 kB CAT, 651, 274432, 274.4 kB CESRC, 0, 12288, 12.3 kB CLI, 21, 16384, 16.4 kB CLI_DAT, 347, 53248, 53.2 kB CNTRY, 154, 32768, 32.8 kB CRIT, 22107, 3018752, 3.0 MB CRNC, 155, 45056, 45.1 kB CRNC_EXCHG, 81, 32768, 32.8 kB CT, 2, 20480, 20.5 kB DHD, 1, 16384, 16.4 kB Feature Expiration Custom Pool, 0, 16384, 16.4 kB FI, 61, 28672, 28.7 kB Goal Custom Pool, 74, 24576, 24.6 kB Inventory Custom Pool, 4, 20480, 20.5 kB ITM, 190, 81920, 81.9 kB IVTY, 0, 32768, 32.8 kB LOT, 3026, 1875968, 1.9 MB LSTEP, 0, 16384, 16.4 kB MAIL, 4, 36864, 36.9 kB MCSRC, 0, 24576, 24.6 kB PAY, 7260, 3080192, 3.1 MB PGM, 0, 16384, 16.4 kB PM_RPT, 2, 16384, 16.4 kB PMT, 0, 28672, 28.7 kB PORT_REC, 8, 20480, 20.5 kB Portfolio View Custom Pool, 13, 20480, 20.5 kB POS_STMT, 34, 28672, 28.7 kB PREF, 20, 20480, 20.5 kB PREF_LIST, 141, 53248, 53.2 kB PRODUCT, 0, 16384, 16.4 kB PROJ, 0, 24576, 24.6 kB PROV_FI, 64, 69632, 69.6 kB PROV_FI_PAY, 73, 40960, 41.0 kB Report Custom Pool, 128, 49152, 49.2 kB SAV_GOAL, 6, 24576, 24.6 kB SCHE_TASK, 0, 16384, 16.4 kB SEC, 145, 131072, 131.1 kB SEC_SPLIT, 11, 12288, 12.3 kB SIC, 160, 16384, 16.4 kB SOQ, 277, 53248, 53.2 kB SP, 31413, 5632000, 5.6 MB STMT, 0, 28672, 28.7 kB SVC, 81, 45056, 45.1 kB Tax Rate Custom Pool, 35, 28672, 28.7 kB Tax Scenario Custom Pool, 1, 20480, 20.5 kB TAXLINE, 81, 16384, 16.4 kB TMI, 0, 28672, 28.7 kB TRIP, 0, 16384, 16.4 kB TRN, 75783, 58044416, 58.0 MB TRN_INV, 2253, 196608, 196.6 kB TRN_INVOICE, 0, 36864, 36.9 kB TRN_OL, 0, 12288, 12.3 kB TRN_SPLIT, 24566, 1552384, 1.6 MB TRN_XFER, 13022, 622592, 622.6 kB TXSRC, 175, 73728, 73.7 kB UI_VIEW, 13, 32768, 32.8 kB UIE, 2, 28672, 28.7 kB UNOTE, 0, 12288, 12.3 kB VIEW, 4229, 434176, 434.2 kB Worksheet Custom Pool, 14, 20480, 20.5 kB X_FMLA, 0, 8192, 8.2 kB X_ITM, 1191, 262144, 262.1 kB X_META_REF, 0, 12288, 12.3 kB X_PARM, 225, 77824, 77.8 kB XACCT, 263, 45056, 45.1 kB XBAG, 52, 32768, 32.8 kB XMAPACCT, 31, 24576, 24.6 kB XMAPSAT, 51, 16384, 16.4 kB XMAPSEC, 33, 28672, 28.7 kB XPAY, 7260, 303104, 303.1 kB XSYNCCHUNK, 0, 16384, 16.4 kB

     Total: 84, 79.0 MB


    Saturday, July 16, 2011 4:12 AM

All replies

  • If you had tracked quotes for a lot of stocks, I expect that would take a significant part of the space. It would be nice if there was the ability to maybe discard qutotes other than the last one of the week or month, for times longer than maybe a year ago. This assumes the space is significant.
    Saturday, July 16, 2011 4:53 AM
    Moderator
  • Cal,

    It seems to me when I was exploring my file using sunriise that quotes weren't regular text - they were "crunched" to save room. 

    Saturday, July 16, 2011 10:25 PM