VBA.EXCEL 16X CORE MULTI-THREADED MULTICOREPROCESSING ARCHITECTURE SOLUTION ENGINE
Standard gem. werden alle Excel VBA Scripte auf dem primären CPU/Kern ausgeführt ( bei 4 CPU Kerne = 25% Problem ). Das Script präsentiert eine Lösung alle 1x - 16x CPU Kerne nativ ohne Third-Party Add-Ons gleichzeitig und simultan zu nutzen um intensive Berechnungen zu parallelisieren und die 100% maximale CPU Leistung der Computers zu nutzen. [ Windows 7/8/10 x86 ]
Mehr als 1400 % Leistungssteigerung von 1 zu 8 CPU Kerne
Standard acc. All Excel VBA scripts are run on the primary core / CPU ( @ 4 CPU Cores = 25% Problem ). The script presents a solution to simultaneously use all 1x - 16x CPU cores native without Third-Party Add-Ons to parallelize intensive calculations and to use the 100% maximum CPU performance of the computers. [ Windows 7/8/10 x86 ]
More than 1400% increase in performance from 1 to 8 cpu cores
- API
- VBA
- CODE LANGUAGE
- VBA Visual Basic for Applications
- CODE LINES
- <2442>
Stay Hungry, Stay Foolish -Steve Jobs Apple
SPECIAL SOLUTION INFORMATIONS
- Application.Wait Method bypasses the Call Sub Problem
- VBS Script allows a new Standalone Excel Instance
- Batch Script for Specifies the processor affinity mask as a hexadecimal number
- External VBComponents Modul for out sourced Work package
- use no debug.print
- Start Engine @RIBBON ICON "START ENGINE"
- Source Code @ VBS, VBA, CMD
Benchmark Intel® Core™ i7-6700K @ 4,44 Ghz
WORKLOAD 6.299.070 Operations @ 2,0 Minutes
| CORE |
TIME | ||
| RUN |
1x CORE |
 |
29,4 min |
| RUN |
2x CORE |
|
8,2 min |
| RUN |
3x CORE |
|
4,2 min |
| RUN |
4x CORE |
|
3,1 min |
| RUN |
5x CORE |
|
3,0 min |
| RUN |
6x CORE |
|
2,7 min |
| RUN |
7x CORE |
|
2,3 min |
| RUN |
8x CORE |
|
2,0 min |
CORE AFFINITY
|
CORE CPUID |
Affinity Hex (h) |
Binary Number |
| CPU 0 | 1 | 0000000000000001 |
| CPU 1 | 3 | 0000000000000011 |
| CPU 2 | 7 | 0000000000000111 |
| CPU 3 | F | 0000000000001111 |
| CPU 4 | 1F | 0000000000011111 |
| CPU 5 | 3F | 0000000000111111 |
| CPU 6 | 7F | 0000000001111111 |
| CPU 7 | FF | 0000000011111111 |
| CPU 8 | 1FF | 0000000111111111 |
| CPU 9 | 3FF | 0000001111111111 |
| CPU 10 | 7FF | 0000011111111111 |
| CPU 11 | FFF | 0000111111111111 |
| CPU 12 | 1FFF | 0001111111111111 |
| CPU 13 | 3FFF | 0011111111111111 |
| CPU 14 | 7FFF | 0111111111111111 |
| CPU 15 | FFFF | 1111111111111111 |
