Enterprise Build Assembly is incredibly SLOW

Switch to single user mode. Any different?

How big is your file size?

Single user is as slow, no difference.

In fact, QuickBooks suggestion was keep an extra user logged onto the server at all times.

Every Monday, at 5 am, I "Rebuild the Files", backup every morning first thing.

File Size: 440,148K

Thanks for helping.

Hello again, @SkipYork. Thanks for keeping us updated.

There are some reasons for performance issues in QuickBooks Desktop (QBDT). These are the following:

• QuickBooks is not updated.
• The computer does not meet the minimum system requirements.
• Damaged or missing QBWUSER.INI file.
• Corrupted hard drive.
• Damaged program files or QuickBooks Desktop installation.
• Damaged Windows operating system

To resolve this problem, check the below articles that cover QBDT performance issues and the recommended steps to fix them:

• Resolve QuickBooks Desktop performance issues: Manage your computers
• Resolve QuickBooks Desktop performance issues: Manage your data file

Please reach out to me here if there's anything I can do to help you succeed. Thanks for dropping in, wishing you a fantastic rest of your day.

@SkipYork 

Next step, run the Condense Data utility to downsize your file. Remove your old transactions and make your file size below 200 MB. Make sure to secure a backup file. Any difference? 

I have set the Condense Data utility in motion.

IT will set up a test company using the latest backup and run the Condense Data utility, if all goes well, they will run it on our company file over the next weekend.

Will advise the results when completed.

Thanks.

Got the same issue, not yet checked the software. But noticed that if I navigate away from QB to say Chrome, the transactions go faster....

This is not the impression we want you to have when using the product. Let's perform some troubleshooting steps to get your QuickBooks Online (QBO) working, jaapkrijger.

Let ensure that QuickBooks is up-to-date and still fits within the system requirements to get the best performance. Here's how to update: 

1. Go to the Help menu and select Update QuickBooks Desktop.
2. From the Update Now tab, click the Reset Update box.
3. Select Get Updates. 
4. Once done click Close

If you're file is a large size, I suggest using the Condense Data utility. This helps streamline your company data file.

Here are some valid reasons to Condense:

• You have a large data file.

• You are nearing a list limit.

• You have upgraded all your hardware.

• Your accountant and your technical support have discussed other options and are willing to proceed with Condensing.

Please check this article for additional information above and how to run a report to determine which transactions it will not condense: Use the Condense Data utility.

Once done, try opening QuickBooks again and see if it works this time. However, if you're getting the same issue, I'd recommend following the remaining solution in this article: QuickBooks Desktop won't open, has stopped working, or not responding

Additionally, here are some helpful references that you can check out about the system requirements for QuickBooks Online, as well as how to improve its performance:

• System requirements for QuickBooks Online, Accountant, and QuickBooks Self-Employed
• Why is my QuickBooks Online slow?
• Resolve QuickBooks Desktop performance issues: Manage your data file 
• Resolve QuickBooks Desktop performance issues: Manage your computers 

Let us know how your call goes by leaving a comment below. I am always here to help you make sure you're able to navigate within QuickBooks smoothly.

I'm running Premium 2016, can I condense?

Hi there,  jaapkrijger. 

Let me help share information about condensing QuickBooks company files.

QuickBooks Desktop allows you to reduce your file’s overall size and still keep all your data and details. This is with the use of the Condense feature.

In line with your question, yes you can condense data using QuickBooks Desktop Premier 2016. Know that being able to condense your file may vary on the version of QuickBooks that you're using. Older versions of QBDT tend to affect the system's performance.

Before you start condensing the company file, you can run a report to see the logic the program uses to determine which transactions it will not condense. Please take note that condensing cannot be undone at a later point. If you wish to continue, follow the steps below:

1. On the top menu, click File.
2. Choose Utilities.
3. Click Condense Data.
4. Select the Remove the transactions you select from your company file radio button and click Next.
5. Choose Transactions before a specific date radio button and enter 12/31/2017.
6. Click Next.
7. Continue the prompts on how you wish to condense and remove your data.
8. Click Begin Condense.

You can check out Use the Condense Data utility for more details about condensing your company file. 

If you need help with other tasks in QBDT, you can browse specific topics here and look for responses that fit your concern.

Please let me know if you have further questions or concerns. I'll be around to lend a helping hand. You can always count on us here in the Community to get you back to business. Take

@jaapkrijger 

You can run the Condense Data utility on your QBD 2016 US version. But if you need to split your files, you have to run it on QBD 2019 US version or later ones.

Ok, I run QB 2016 Premier Accounts version UK....

Another trick I found out, if you click build and new, its quicker than build and close. You can still close the input screen once the build has been posted

How large should my company file be, currently its about 65 Mb.

How many items should there be on the lists? Is there a place where I can check?

My items list has about 300 items, there are more to be added over next 2 months or so.

UK 2016 so can't condense.

Have check software and OS, all seems to be fine

Seems I can't update, think my version is no longer supported by Intuit? Gives me error 12007

I'm sorry this doesn't help but it's taking me upwards of 8-10 minutes per build, which means hours dedicated to just builds.  I do them in Single User Mode because if they're done while everyone else is working, they get error messages saying they can't complete their task (creating sales orders, invoices, entering bills, entering customer payments, etc.) until I finish my task (the assembly build) and since the builds take SO incredibly long, we can't afford to waste that kind of time.  Sometimes, QuickBooks is the worst.

@ColleenHarviaUS 

How big is your file size? Run the Condense Data utility to reduce it.

Yet another trick that seems to cutting a few seconds of the time QB takes. On, https://stackoverflow.com/questions/6124713/why-is-database-access-sql-server-slower-on-windows-7

Root Cause

The issue which we were seeing on Win7 VDIs could be due to the Network hardware device connected with the machine. If TCP/IP scaling is not supported by the network device then the performance will be slow.

Solution

Disable auto tuning level of the TCP. Please follow below steps: 1) Open command Prompt with admin right (Run as Admin) 2) Type “netsh interface tcp set global autotuninglevel=disabled” 3) After running above command restart the machine.

For other information on this command, visit link “http://support.microsoft.com/kb/935400”

Could be me, but it seems to have an effect on the processing speed....