Does Peachtree Accounting need to be upgraded to "Quantum"

Posted on 2009-02-13
Last Modified: 2013-11-15
My client uses Peachtree Accounting software.  They have 4 users and their database size is 250MB.  Recently, a salesperson from Peachtree contacted them about upgrading to Peachtree Accounting Quantum, which uses a SQL backend.  Evidently, they don't recommend using a database size over 100MB with Peachtree standard and it only supports up to five users.  The user issue isn't a big deal (they don't plan on having anyone else use it) but the database issue concerned me.

Does anyone have any experience with either product and whether the need to upgrade is crucial to the program's performance?  Any thoughts or input will be greatly appreciated.

Vic Wukovits
Question by:wukovits
    LVL 28

    Accepted Solution

    PeachTree is based on a Pervasive database, either Btrieve 6.15, Pervasive PSQL v9, or Pervasive PSQL Summit v10, depending on the version of PeachTree you are running.  

    All of these databases, even in the WorkGroup Edition (WGE) provided by PeachTree, are not artificially limited to database size.  Btrieve 6.x has a maximum capacity of 4GB per file, whereas PSQLv9 and PSQLv10 have a maximum capacity of 256GB per file.

    As the database grows, of course, then there may be some performcne tweaks that you can do.  A "default" WGE engine creates a 32MB memory block for the data cache in RAM, which is where the "work" of the database is done.  As your system grows, you'll want to increase this size.  

    How far to increase it depends on your data and the system acting as the database server.  If the box has plenty of free memory, then increasing cache from 32MB to 250MB would provide the ability for the entire database to be cached!  This setting is easily changed in the Pervasive Control Center (if they give it to you), or by manually editing the Cache Size setting in the registry under HKLM/Software/Pervasive Software/Microkernel Workgroup Engine/Version 10/Settings.  A restart of the engine (or a reboot) is required to change this setting permanently.

    Author Comment

    So they should be able to stay with their current version, provided they have enough RAM and HD space to accomodate theie 250MB database?  They're currently upgrading their machines to units with 2GB RAM and 250GB hard drives, so would that suffice for their current and future needs?

    All in all, should they spend $4000 on upgrading to Peachtree Quantum?
    LVL 28

    Assisted Solution

    by:Bill Bach
    Quantum may have additional features (such as more users, better reporting, etc.) that may drive them to it.  However, lack of performance via the database is not an issue that would force them to upgrade.   BTW, with 2GB on the server, increasing the cache size to as high as 600MB is easily possible.  Don't do this now, since 350MB will be wasted, but just know that there's plenty of room for expansion.

    Author Comment

    Many thanks!!

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SaaS ERP and accounting systems for SMEs 6 439
    GP 2010 - Payroll checks 5 316
    Corrupt QBW File 8 108
    User Account Control Message for Sage 50 3 88
    A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
    Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video discusses moving either the default database or any database to a new volume.

    734 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

    21 Experts available now in Live!

    Get 1:1 Help Now