Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ Protecting Your Data

+ Goldstar Services

+ Goldstar Tools

+ Developer Resources

+ Other Solutions

Using AMS? Status 7224 Fix My PSQL License Report Engine Crash Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

PSQL Server Engine Versus Workgroup Engine

There are two different levels of the Pervasive PSQL / Actian PSQL database engine. What are the real differences between the PSQL Workgroup Engine (WGE) and the PSQL Server Engine?.

The Short Answer

If you just need a quick comparison, then you are in the right section. Succinctly, the core code within the engines is the same, but the PSQL Workgroup Engine is licensed for small workgroups (up to 5 concurrent users at most) and is priced considerably lower as a result. The Server Engine is for systems with 6 or more users, or those that need additional security or features of the Server Engine.

The Long Answer

Additional security? Features? I thought the engines were the same? Indeed -- the two engines share the same CORE code, but they do have some minor differences that are highlighted here:

Feature
Workgroup
Server
Maximum Simultaneous User (User Count) Supported
1 to 5 ONLY
6 to 500+
User Count Increases Available
1U, 2U (to 5U Max)
6, 10, 20, and up
Backup Agent
Additional Cost
Included FREE
VSS Writer
Not Available
Included FREE
Available 32-Bit Engine
YES
YES
Available 64-Bit Engine
NO
YES
Available Linux Engine (32-bit and 64-bit)
NO
YES
Supports 64-bit Applications
YES (With 64-bit Client)
YES
Available PSQL Vx Server (Licensing for Virtual Machines, ThinClient, SaaS)
NO
YES
OS Security Enabled (Validates that all users have access to files)
NO
YES
Can Access Data on Remote Server or NAS (Though not recommended)
YES
NO
Default Memory Allocated for L1 Database Cache (Can be changed)
10% of RAM or 64MB
20% of Memory Space
Maximum Memory Space Supported on 32-bit OS
2 GB
2 GB
Maximum Memory Space Supported on 64-bit OS
4 GB
4 GB (32-bit Engine)
8 TB (64-bit Engine)

If you are trying to decide between the Workgroup and Server Engine for your primary server, then security may be an important attribute to consider, as well as the performance gains available on the 64-bit Server Engine. Remember that any user on the network can access data on the Workgroup Engine. With the Server Engine, users must authenticate to the server and.or domain before they can access files. For test servers, however, especially if it is running a very small data set, then the Workgroup Engine may fill all of your needs and save you a bundle, too!

 

If you have additional questions about the product, please contact us!

  Copyright © 1997-2024, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us