Kbase P122981: Why performance does not scale with the Workgroup license on SMP systems based on the Intel architec
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/03/2007 |
|
Status: Verified
GOAL:
Why performance does not scale with the Workgroup license on SMP systems based on the Intel architecture
GOAL:
Why is performance slower as more CPU's are added ?
FIX:
The performance issue with Workgroup Database when multiple CPUs or CPU cores are in use is due to a limitation in the underlying operating system implementation. More specifically, the Workgroup database server uses so-called "semaphores" to synchronize access to shared resources between multiple processes. The semaphore mechanism does not scale well on multiple platforms with modern operating systems.
This limitation does not apply to Enterprise Database because Enterprise DB can use "spinlocks" instead of semaphores for this purpose, using the -spin startup parameter. Spinlocks do not have this scalability issue.
At this time there are no plans to change the Workgroup database engine to enable the use of spinlocks instead of semaphores.