Some of my reports are very slow

spaman

Some reports are fast and some say searching transactions and take a long time. Did not do that before. Nothing changed. 

Rocket J Squirrel

Try the "Fourth, Copy your file and Validate" step on this troubleshooting page.
If that doesn't help, you'll have to tell us exactly which reports are fast and which are slow and we can take a look.

spaman

it did not work. how do i tell you the reports

Rocket J Squirrel

Every report has a name, visible in the upper left of its window.

spaman

these are my reports that I named: Business expenses by year, then the one that works: tax categories

Jim_Harman

When you say the copy and validate did not work, did it fail in some way, or did it complete successfully but the reports are still slow?

Are the slow reports ones that you have customized and saved, or do some of the standard reports accessed from the Reports > Banking , spending, investing, etc. menus running slowly? If so which ones are slow? 

spaman

validate worked but reports slow. These are all customized reports (for taxes)
It makes no sense why some slow and others not. the slow one is just a standard one item detail for a particular category over last 3 years. 

spaman

stuck on searching transactions. 

Rocket J Squirrel

Let's have a look at your Quicken's innards. Do Help, then hold CTRL while clicking About Quicken. Show us the resulting display, which shows various statistics about the size of your data.

Jim_Harman

Sometimes internal changes to Quicken cause problems with older saved reports.

You might try starting with the standard report and making the same customizations as the problem report and seeing if the new report has the same problems.

If you share the starting report and what customizations were made, we can try it and see if it runs slow with our data as well.

spaman

Here it is

spaman

Jim, I think you have the best idea and it makes sense. I will just recreate the reports. 

NotACPA

@spaman, are you using attached statements, or other images, to your Q transactions? Because your "Size of QDF file" is quite large.

Also quite large is your number of Memorized Payees.  Your might consider a "Renaming Rule" so that "Gas Station #247" and "Gas Station # 298" are both recorded as simply "Gas Station" and you can delete all of the presumably redundant payees.

I'd also suggest that you turn OFF "Automatically Memorize new Payees" and set your "Remove memorized Payees ..." value to something smaller.  Mine is set at 4 months, and that covers everything except my annual RE tax payment and other "Scheduled Transactions".  The only Memorized payees that I have are recurring (weekly, monthly, etc) transactions.  These settings are at: EDIT, Preferences, "Data entry & Quickfill"

All of these suggestions will reduce the size of your Q data file ... and thus speed up your reports.

Rocket J Squirrel

NotACPA said:

@spaman, are you using attached statements, or other images, to your Q transactions? Because your "Size of QDF file" is quite large.

That's the size of the inner QDF, not counting attachments. So it is very large as are numbers of payees, securities, and transactions. That's a big file.

With that many securities, it might be worthwhile to do an Archive of the investment accounts. This would move securities no longer held into new archive accounts and then reports could be restricted not to include those accounts.

Recreating the reports is the easiest thing to try, but if that doesn't help, try Archive Transactions from the investment accounts' gear menu.

q_lurker

Before you archive investments, be sure to have a good backup at hand - mostly in case you don't like the results.  (I have not personally worked with having archived investment transactions and securities, so I can't comment on what issues it might raise.) 

FWIW, I don't consider 552 securities "that many".  I don't think that is the cause of your issues.