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

Does Peachtree Accounting need to be upgraded to "Quantum"

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
0
wukovits
Asked:
wukovits
  • 2
  • 2
2 Solutions
 
Bill BachPresidentCommented:
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.
0
 
wukovitsAuthor Commented:
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?
0
 
Bill BachPresidentCommented:
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.
0
 
wukovitsAuthor Commented:
Many thanks!!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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