Kbase P122980: What features separate Enterprise from Workgroup database licenses?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2010 |
|
Status: Verified
GOAL:
What features separate Enterprise from Workgroup database licenses?
GOAL:
Is an Enterprise License different than the Workgroup License?
GOAL:
What are the differences between Enterprise and Workgroup rdbms
GOAL:
Compare a workgroup database to an Enterprise database.
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.0x
FIX:
Workgroup licenses allow development and deployment of multi-user applications for a modest application load. As more demand is required of the application, it may be necessary to accommodate higher user counts and larger databases, thus the need to move to the Enterprise product.
There is a real and substantial performance benefit to the Enterprise product as the table below shows, through the availability of performance features. Benchmarks on 2-5GB databases show an order of magnitude or more difference. As more users, CPU and memory are added to the environment, the advantage of Enterprise performance over WorkGroup is rapidly apparent.
The following is a summary table showing the primary features that separate the two products.
Feature
Enterprise
Workgroup
After Image Writers
X
NO
Asynchronous Page Writers
X
NO
Before Image Writers
X
NO
Failover Cluster Support
X
NO
Fathom Replication
X
10.1B01[1]
Large Files
X
NO
Maximum Number of Users
32,000
49
Multi-threaded Binary Dump
X
1 thread
Quiet Point
X
ace=Arial size=3>
NO
SMP spinlocks
X
10.1B01[2]
SMP Support
X
X[3]
Variable Database Blocksize
X
NO
[1] Although OpenEdge Replication for Workgroup was initially made available in OpenEdge 10.1B (FCS) with limited functionality, it was not a public release for Production environments. The recommendation is to apply the OpenEdg