Solved

Quickbooks slow

Posted on 2013-02-01
8
411 Views
Last Modified: 2016-11-23
I have a new customer who was complaining of slowness with Quickbooks.  It is the server version of QB2008 with 4 simultaneous users on a Dell sc440 with win server 2003.
I added memory to bump it from 1 gig to 3 hoping that would solve the problem and it did not.  The QB Database itself is large and goes back 4 years.

How can I speed this up?  Is there a way to archive the database so just the last 2 years are active without losing all the custom drop down lists, etc.  Or is there a way to provision more of the new memory to QB?

Any advice would be greatly
0
Comment
Question by:jbasiliere67
  • 4
  • 3
8 Comments
 
LVL 92

Expert Comment

by:John Hurst
ID: 38845901
Is there a way to archive the database See if your version has the ability to condense the Company database. Be very careful with Condense and be certain to have a backup before trying it. The goal is to reduce the database size.

If the Condense function is not there, then you need to look at 3rd party tools to condense it. I included one such link below here.

http://quickbooksusers.com/file-shrink.htm


Otherwise, you need to look at having QuickBooks on its own server to make a real gain.

Or is there a way to provision more of the new memory to QB?  No, not really.

QuickBooks is naturally slow, so you will have to let your customers know this as well.
0
 

Author Comment

by:jbasiliere67
ID: 38898675
Hi,

I do have QB on it's own server and as I've said recently bumped the memory on theserver to the max of 3 gig.  

When I try the compression utility or the archive as of certain date utility, it freezes.  I think the archive utility will work for me because the my customer reports that his newer clients with just a few transactions in the system open quickly and perform fast.  It is his clients with high volume of transactions in their record that are slow.  I would guess that if I can archive the data base so that only the last year of transactions are active, then even the large volume customers records will open more quickly.  

As you mentioned, when I try to do this I have to back up and verify data.  It is during this process that QB freezes.  Any ideas on this?

Thanks fro the help.

John
0
 
LVL 92

Expert Comment

by:John Hurst
ID: 38899066
Copy (not move) the QuickBooks database to a local machine that has QuickBooks.

Open the QB database locally and then do a verify. See if the verify completes.  If it does, do a rebuild (again locally) and allow to rebuild.

If the verify does not work, try a Rebuild without first verifying. This can be done. Make certain you are working locally.

If you cannot verify and cannot rebuild, you will need to contact Intuit Support and use their repair service. They have the tools to fix databases.

Once sorted out (one way or the other from the above), you should be able to compress the database.

.... Thinkpads_User
0
 

Author Comment

by:jbasiliere67
ID: 38905334
OK.  Thanks.  I won't be able to try until this weekend.  Will post results and point then.

Thanks!
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Expert Comment

by:rkedia99
ID: 39022148
You might want to go through the following post on increasing the cache used by QuickBooks database to improve performance.

http://forums.quickbooksusers.com/archive/index.php/t-39666.html

Regards

- Rajiv
0
 

Author Comment

by:jbasiliere67
ID: 39037430
Thanks.  I'll give check out the article and give it a try.  I was able to copy the file to a local computer but kept recieving "Data related errors" which did not allow the rebuild to complete.
0
 
LVL 92

Accepted Solution

by:
John Hurst earned 500 total points
ID: 39037451
but kept receiving "Data related errors" which did not allow the rebuild to complete.

If you cannot rebuild the file locally, you need to contact Intuit Support. They may need to service the file to remove errors. That, in turn, may account for the slowness. But in any event, the file should get repaired.

... Thinkpads_User
0
 
LVL 92

Expert Comment

by:John Hurst
ID: 39107693
@jbasiliere67 - Thank you, and I was happy to help you here.

... Thinkpads_User
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Copy an entire Active Directory Domain to a dev environment 4 104
Best practice DHCP migration 7 63
Domain Share problems 5 48
User profile Size Report 3 64
Organizations create, modify, and maintain huge amounts of data to help their businesses earn money and generally function.  Typically every network user within an organization has a bit of disk space to store in process items and personal files.   …
Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now