• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Quickbooks slow

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
jbasiliere67
Asked:
jbasiliere67
  • 4
  • 3
1 Solution
 
John HurstBusiness Consultant (Owner)Commented:
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
 
jbasiliere67Author Commented:
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
 
John HurstBusiness Consultant (Owner)Commented:
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
jbasiliere67Author Commented:
OK.  Thanks.  I won't be able to try until this weekend.  Will post results and point then.

Thanks!
0
 
rkedia99Commented:
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
 
jbasiliere67Author Commented:
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
 
John HurstBusiness Consultant (Owner)Commented:
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
 
John HurstBusiness Consultant (Owner)Commented:
@jbasiliere67 - Thank you, and I was happy to help you here.

... Thinkpads_User
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now