Solved

Quickbooks slow

Posted on 2013-02-01
8
410 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 90

Expert Comment

by:John Hurst
Comment Utility
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
Comment Utility
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 90

Expert Comment

by:John Hurst
Comment Utility
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
Comment Utility
OK.  Thanks.  I won't be able to try until this weekend.  Will post results and point then.

Thanks!
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Expert Comment

by:rkedia99
Comment Utility
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
Comment Utility
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 90

Accepted Solution

by:
John Hurst earned 500 total points
Comment Utility
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 90

Expert Comment

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

... Thinkpads_User
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

So you have two Windows Servers and you have a directory/folder/files on one that you'd like to mirror to the other?  You don't really want to deal with DFS or a 3rd party solution like Doubletake. You can use Robocopy from the Windows Server 200…
Learn about cloud computing and its benefits for small business owners.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 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

7 Experts available now in Live!

Get 1:1 Help Now