My data file is quite big and the application is very slow

shabandri
shabandri Quicken Windows Subscription Member ✭✭
in Registers & Transactions (Windows)

My data file is quite big and the application is very slow. Is there a best practice on the number of years info that can be kept in a data file? I was suggested to validate the file .. I dont have any action out of the validation

I have been using Quicken since 2005 and am presently on release R60.15 Build 27.1.60.15

Appreciate any pointers.

Answers

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    Define "quite big"?

    Quicken's performance almost never has anything to do with the size of the data file.

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭

    How big is "quite big"?

    How slow is "very slow"?

    Go to Tools > Account list. Click on Options at the bottom left and make sure "Show number of transactions" is selected. What is the largest number of transactions in each account type?

    Generally slow operation is more affected by the number of transactions in an account than the age or size of the file. Usually there are better options to improve performance than trying to reduce the size of your data file.

    For example, my data file is about 200 megs and I do not experience any significant slowdowns. The largest number of transactions in each account type are about:

    • Spending 9,600
    • Savings 600
    • Credit 5,400
    • Investment 950
    • Retirement 550

    QWin Premier subscription
  • shabandri
    shabandri Quicken Windows Subscription Member ✭✭

    As I had mentioned earlier … I have information since 2005 and the data file is 171 megs. It takes over 5 secs to accept one downloaded transaction. Here are the number of transactions in each account type:

    • Spending - 8500
    • Savings - 65
    • Credit - 18409
    • Investment - 2748
    • Retirement - 1352

    Thanks

  • Unknown
    Unknown
    This content has been removed.
  • omandel
    omandel Quicken Windows Subscription Member ✭✭

    I have the same issue.
    My data is from ~2005. The data file is 160MB.

    I have over 200 accounts (most are closed). The biggest accounts are one savings account with more than 6,000 transactions and two spending accounts with more than 6,000 and over 7,000 transactions, respectively.

    The response has been very slow in the last year. When I download transactions from the QIF file, it takes 4-5 seconds per transaction. When accepting a downloaded transaction, it takes 1-3 seconds per transaction. Moving between accounts is very slow.

    Any suggestion on how to optimize the data or should I split the biggest account into archive and active part>

  • Yelnak
    Yelnak Member ✭✭✭

    I'd had the same issue… 400MB data file taking 3 secs per transaction.

    This page helped me: Troubleshooting

  • Craig069
    Craig069 Quicken Windows Subscription Member
    edited January 4

    My data file is only 312MB and I was advised it is not necessary to close out years. Well this is not true if speed is important. Making a backup file at year end and starting over is the only way I know of to improve response times. The large data file was taking 5-6 secs per changed transaction. Their data structure on Quicken Business Classic for PC in my opinion is very poor. I have a customer using a commercial accounting program using a SQL database and transactions take milliseconds for a 9GB database. It's all about proper indexing. I am running a HP Xeon Z4 workstation with 16GB RAM.

Categories