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

 

VBA.EXCEL 16X CORE MULTI-THREADED MULTICORE--PROCESSING ARCHITECTURE SOLUTION ENGINE

Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
More information Ok