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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Craig BowmanIT Services ManagerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ZillionTechCommented:
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
JohnBusiness 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
stlinaeCommented:
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
ZillionTechCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.