Mark all cleared performance problem
After doing a massive import of data from Mint, I was going through and marking everything as cleared (after ensuring it was all correct). Something doesn't scale well. If I clear "a few" transactions, it completes quickly. If I clear "many" transactions, the program hangs for a few seconds. If I clear "a lot" of transactions, it hangs for a long time. It's hung up right now, so I can't give you counts for all of the cases quite yet, but I think I'm trying to clear 1000-2000 transactions right now, and I'm up to > 30 minutes.... (CPU at 100%).
I downloaded '11 about 2 weeks ago. I can check the build # once I get control of the program back.
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
1 Posted by Ben Spencer on 31 May, 2011 01:01 PM
Its almost certainly caused by an update event being fired by each transaction as it is cleared. This update event will cause certain parts of the program to be reinitialised to show the up-to-date information including the recalculation of the cleared balance. Can you tell me the account type you are using (e.g. bank, investment). And can you confirm that you are using the BatchChange->Mark as Cleared... to clear these transactions?
Ben Spencer
Moneydance Support
2 Posted by oberman on 31 May, 2011 02:28 PM
Here's the full sweep:
-I thought I marked all transactions as cleared -I went to the transactions report, and did a filter on "uncleared" -There were a lot of hits (first on old accounts that were hidden, but then also in new accounts) -I started to clear "the other side" of income/expenses and the uncleared list was shrinking. E.g. if I had a transaction marked as "Bank Fee", and it was cleared in my Bank Account, I went to the Bank Fee category list (which was listed as uncleared) and cleared it and then it was removed from the report -This was going well until I did a bulk clear on Salary (which had 1000's of transactions).
To do the bulk operation I did ctrl-A, right click, and then selected to clear them all (I'm at work now, and I can't confirm the exact menu option until tonight).
3 Posted by oberman on 31 May, 2011 11:17 PM
I didn't think about it this morning, but why do I have to clear "the other side" of income and expense categories? That will be a real pain to continue doing moving forwards, but I'd like the report of transactions + uncleared to match things that haven't cleared ACCOUNTS (or is the root problem the strong relationship between categories and accounts?)
4 Posted by oberman on 01 Jun, 2011 12:05 PM
I just checked, and I did command-A, right click, mark as cleared. I don't know how to quickly count # of transactions though.
5 Posted by Ben Spencer on 02 Jun, 2011 03:47 PM
You are correct you don't need to clear "the other side". It doesn't really make sense to clear a transaction in an expense/income account as the account is not associated with a bank.
If you specify a particular bank account in the transactions report that you want to run the report on you will get the result you are expecting and wanting.
However if you don't specify a particular account to run the report on it will run on all account including income and expense accounts. This will include the other side in the search results. The results might seem especially confusing if you had entered the originating transaction in the expense account rather than the bank account.
Sincerely
Ben Spencer
Moneydance Support
System closed this discussion on 31 Mar, 2015 03:33 PM.