How big is too big for a QB data file?

A user has quickbooks premier 2008 running on a not too old laptop with 3 GB of RAM.  It takes upwards of a minute to record an invoice or do most anything else.

Is there an easy way to tell if a faster machine will make a difference?  Or is that database size just too large for most any machine?

It's a 400MB database.  We've packed it / run the database utilities.

The invoices only have 4 - 10 items and each item is a single line of description (we aren't saving 50 page invoices for building a mansion type  of thing : )
IamStumpedAsked:
Who is Participating?
 
Craig BowmanConnect With a Mentor IT Services SupervisorCommented:
quickbooks support will tell you anything over 150000 Kb is too big.  Some people say a file larger to than 250mb should be upgraded to enterprise solutions and that putting additional memory into that machine wont make pro or premier any faster, as the performance is lower in these editions compared to enterprise. (info pulled from site below)

check out more on this subject at http://smallbusinessonlinecommunity.bankofamerica.com/message/41641

Cb
0
 
ZillionTechConnect With a Mentor Commented:
IT's not a matter of how large your data file is -- it's a matter of whether your file is optimized. If operations take too long, you need to optimize the data file.
0
 
John HurstConnect With a Mentor Business Consultant (Owner)Commented:
400Mb is not too big for such a laptop. I can easily run files as big or bigger on my own laptop (faster than yours) with responses of 1 or 2 seconds or less.

Things to do:
1. Run a Verify to see if your data is OK (File -> Utilities). If it flushes out errors, run a Rebuild.
2. Even if no errors, consider running a rebuild anyway (I think that may be what is referred to above as optimized).
3. Then quit QuickBooks and run a complete disk defrag on your computer.

Per the comment on Enterprise. I have run it in controlled conditions and do not find it any faster than a well-oiled non-enterprise installation. Enterprise is expensive and genernally non-reversible. Do not go there without thoroughly testing first.

... Thinkpads_User
0
 
stlinaeConnect With a Mentor Commented:
As you can see, there are all sorts of thoughts on this question. There is no "offical" size tht Intuit will tell you. If a support agent gives you a size, then the're speaking on their own, not based on what they were trained.

Is the actual file on the laptop?

There are all sorts of things that can slow down a data file. Do you have sub accounts, sub items, sub jobs? Depending on how many and how many levels you have, this can impact the speed of the file.  Do you hae Assemblies? These also impact how fast things run.

In short, there is no set answer to you question. It sounds like something is certainly a miss with the file, but without the right support plan and right support rep, you may never know.

I would not upgrade your system or version just to try to gain speed at this point.l
0
 
ZillionTechConnect With a Mentor Commented:
I agree with Thinkpads_user, there is no significant performance gains by using QB Enterprise. See the difference between Quickbooks Pro, Premier and Enterprise here:
http://www.qbconvert.com/Differences-between-Enterprise-Premier-and-Pro.aspx
0
All Courses

From novice to tech pro — start learning today.