Hardware Configuration

  • Computer - System76 Thelio-r2
  • CPU - 4.7 GHz AMD 3rd Gen Ryzen 9 3950X (3.7 up to 4.7 GHz - 16 Cores - 32 Threads)
  • 1× 64 GB Dual Channel DDR4 @ 3000 MHz (2x 32GB)
  • SSD - 1× 2 TB PCIe Gen4 Seq Read: 5,000 MB/s, Seq Write: 4,400 MB/s
  • Simulated within VMWare Workstation with the following resources
    •  8 CPUs
    • 16 GB RAM
    • 1 TB SDD

Benchmark Criteria

Criteria for G-Partition Bench Marks - 3 Domains Criteria for G-Partition Bench Marks - Single Domain
  • CustomerScenario
  • Domains (Organization to Location to Customer)
    • 13 Attributes
  • Generating 100,000,000 Records
  • OptimizeAttributes = true
  • UserScenario
  • Domain (User)
    • 13 Attributes
  • Generating 100,000,000 Records
  • OptimizeAttributes = n/a



G-Partition Bench Marks - 3 Domains
G-Partition Bench Marks - Single Domain

15 instances 

Elapsed time is 32m:0s:346ms for server 1, instance 5

Elapsed time is 32m:17s:765ms for server 1, instance 6

Elapsed time is 32m:20s:271ms for server 1, instance 7

Elapsed time is 32m:26s:378ms for server 1, instance 3

Elapsed time is 32m:21s:958ms for server 1, instance 8

Elapsed time is 32m:26s:797ms for server 1, instance 4

Elapsed time is 32m:18s:792ms for server 1, instance 12

Elapsed time is 32m:17s:278ms for server 1, instance 15

Elapsed time is 32m:21s:876ms for server 1, instance 11

Elapsed time is 32m:30s:361ms for server 1, instance 1

Elapsed time is 32m:25s:104ms for server 1, instance 9

Elapsed time is 32m:24s:296ms for server 1, instance 10

Elapsed time is 32m:23s:478ms for server 1, instance 13

Elapsed time is 32m:34s:600ms for server 1, instance 2

Elapsed time is 32m:25s:715ms for server 1, instance 14


15 instances

Elapsed time is 31m:55s:869ms for server 1, instance 1

Elapsed time is 32m:12s:128ms for server 1, instance 3

Elapsed time is 32m:12s:229ms for server 1, instance 4

Elapsed time is 32m:16s:670ms for server 1, instance 2

Elapsed time is 32m:13s:592ms for server 1, instance 8

Elapsed time is 32m:17s:872ms for server 1, instance 5

Elapsed time is 32m:15s:933ms for server 1, instance 7

Elapsed time is 32m:14s:805ms for server 1, instance 11

Elapsed time is 32m:12s:256ms for server 1, instance 15

Elapsed time is 32m:17s:400ms for server 1, instance 10

Elapsed time is 32m:23s:626ms for server 1, instance 6

Elapsed time is 32m:19s:849ms for server 1, instance 12

Elapsed time is 32m:23s:226ms for server 1, instance 9

Elapsed time is 32m:19s:698ms for server 1, instance 13

Elapsed time is 32m:19s:619ms for server 1, instance 14


14 instances

Elapsed time is 36m:47s:290ms for server 1, instance 7

Elapsed time is 36m:48s:143ms for server 1, instance 11

Elapsed time is 36m:57s:62ms for server 1, instance 3

Elapsed time is 37m:3s:46ms for server 1, instance 1

Elapsed time is 37m:4s:756ms for server 1, instance 2

Elapsed time is 36m:52s:983ms for server 1, instance 14

Elapsed time is 37m:1s:653ms for server 1, instance 6

Elapsed time is 37m:3s:651ms for server 1, instance 8

Elapsed time is 37m:8s:27ms for server 1, instance 5

Elapsed time is 37m:0s:106ms for server 1, instance 13

Elapsed time is 37m:1s:428ms for server 1, instance 12

Elapsed time is 37m:5s:475ms for server 1, instance 9

Elapsed time is 37m:11s:346ms for server 1, instance 4

Elapsed time is 37m:5s:785ms for server 1, instance 10


14 instances

Elapsed time is 31m:18s:294ms for server 1, instance 5

Elapsed time is 31m:27s:254ms for server 1, instance 6

Elapsed time is 31m:20s:990ms for server 1, instance 13

Elapsed time is 31m:25s:977ms for server 1, instance 11

Elapsed time is 31m:34s:144ms for server 1, instance 3

Elapsed time is 31m:33s:370ms for server 1, instance 4

Elapsed time is 31m:28s:413ms for server 1, instance 9

Elapsed time is 31m:38s:657ms for server 1, instance 1

Elapsed time is 31m:31s:552ms for server 1, instance 10

Elapsed time is 31m:38s:951ms for server 1, instance 7

Elapsed time is 31m:47s:712ms for server 1, instance 2

Elapsed time is 31m:42s:406ms for server 1, instance 8

Elapsed time is 31m:38s:634ms for server 1, instance 12

Elapsed time is 31m:38s:793ms for server 1, instance 14


13 instances

Elapsed time is 36m:46s:665ms for server 1, instance 2

Elapsed time is 36m:48s:860ms for server 1, instance 1

Elapsed time is 36m:50s:689ms for server 1, instance 3

Elapsed time is 36m:49s:379ms for server 1, instance 6

Elapsed time is 36m:50s:970ms for server 1, instance 5

Elapsed time is 36m:44s:846ms for server 1, instance 12

Elapsed time is 36m:55s:366ms for server 1, instance 4

Elapsed time is 36m:53s:294ms for server 1, instance 7

Elapsed time is 36m:57s:319ms for server 1, instance 11

Elapsed time is 37m:0s:515ms for server 1, instance 10

Elapsed time is 37m:1s:427ms for server 1, instance 13

Elapsed time is 37m:7s:996ms for server 1, instance 8

Elapsed time is 37m:10s:835ms for server 1, instance 9


13 instances

Elapsed time is 31m:38s:408ms for server 1, instance 1

Elapsed time is 31m:31s:905ms for server 1, instance 8

Elapsed time is 31m:40s:340ms for server 1, instance 4

Elapsed time is 31m:40s:69ms for server 1, instance 6

Elapsed time is 31m:38s:232ms for server 1, instance 9

Elapsed time is 31m:54s:679ms for server 1, instance 2

Elapsed time is 31m:53s:953ms for server 1, instance 3

Elapsed time is 31m:51s:475ms for server 1, instance 7

Elapsed time is 31m:47s:142ms for server 1, instance 12

Elapsed time is 31m:49s:973ms for server 1, instance 10

Elapsed time is 31m:55s:246ms for server 1, instance 5

Elapsed time is 31m:53s:685ms for server 1, instance 11

Elapsed time is 31m:54s:863ms for server 1, instance 13


12 instances

Elapsed time is 36m:56s:983ms for server 1, instance 1

Elapsed time is 36m:56s:385ms for server 1, instance 8

Elapsed time is 36m:59s:353ms for server 1, instance 7

Elapsed time is 37m:6s:987ms for server 1, instance 3

Elapsed time is 37m:9s:939ms for server 1, instance 2

Elapsed time is 37m:13s:560ms for server 1, instance 4

Elapsed time is 37m:10s:511ms for server 1, instance 12

Elapsed time is 37m:16s:940ms for server 1, instance 6

Elapsed time is 37m:13s:315ms for server 1, instance 11

Elapsed time is 37m:17s:106ms for server 1, instance 9

Elapsed time is 37m:16s:159ms for server 1, instance 10

Elapsed time is 37m:22s:262ms for server 1, instance 5


12 instances

Elapsed time is 31m:43s:595ms for server 1, instance 2

Elapsed time is 31m:41s:649ms for server 1, instance 9

Elapsed time is 31m:47s:332ms for server 1, instance 4

Elapsed time is 31m:50s:5ms for server 1, instance 6

Elapsed time is 31m:46s:271ms for server 1, instance 10

Elapsed time is 31m:46s:570ms for server 1, instance 11

Elapsed time is 31m:50s:207ms for server 1, instance 12

Elapsed time is 31m:56s:329ms for server 1, instance 8

Elapsed time is 32m:1s:850ms for server 1, instance 3

Elapsed time is 32m:1s:610ms for server 1, instance 5

Elapsed time is 32m:11s:458ms for server 1, instance 1

Elapsed time is 32m:5s:630ms for server 1, instance 7


11 instances

Elapsed time is 37m:13s:350ms for server 1, instance 10

Elapsed time is 37m:14s:747ms for server 1, instance 9

Elapsed time is 37m:20s:360ms for server 1, instance 5

Elapsed time is 37m:18s:205ms for server 1, instance 8

Elapsed time is 37m:28s:195ms for server 1, instance 2

Elapsed time is 37m:29s:706ms for server 1, instance 3

Elapsed time is 37m:27s:477ms for server 1, instance 6

Elapsed time is 37m:33s:340ms for server 1, instance 1

Elapsed time is 37m:25s:923ms for server 1, instance 11

Elapsed time is 37m:34s:384ms for server 1, instance 4

Elapsed time is 37m:35s:711ms for server 1, instance 7


11 instances

Elapsed time is 31m:22s:330ms for server 1, instance 4

Elapsed time is 31m:24s:334ms for server 1, instance 8

Elapsed time is 31m:36s:456ms for server 1, instance 3

Elapsed time is 31m:31s:854ms for server 1, instance 11

Elapsed time is 31m:44s:809ms for server 1, instance 1

Elapsed time is 31m:43s:55ms for server 1, instance 6

Elapsed time is 31m:47s:484ms for server 1, instance 5

Elapsed time is 31m:44s:320ms for server 1, instance 9

Elapsed time is 31m:43s:643ms for server 1, instance 10

Elapsed time is 31m:52s:831ms for server 1, instance 2

Elapsed time is 31m:52s:810ms for server 1, instance 7


10 instances

Elapsed time is 37m:26s:707ms for server 1, instance 3

Elapsed time is 37m:33s:231ms for server 1, instance 1

Elapsed time is 37m:37s:316ms for server 1, instance 2

Elapsed time is 37m:34s:695ms for server 1, instance 5

Elapsed time is 37m:36s:190ms for server 1, instance 4

Elapsed time is 37m:34s:564ms for server 1, instance 6

Elapsed time is 37m:33s:178ms for server 1, instance 8

Elapsed time is 37m:33s:566ms for server 1, instance 10

Elapsed time is 37m:38s:723ms for server 1, instance 7

Elapsed time is 37m:37s:384ms for server 1, instance 9


10 instances

Elapsed time is 31m:54s:668ms for server 1, instance 3

Elapsed time is 31m:57s:284ms for server 1, instance 1

Elapsed time is 32m:0s:920ms for server 1, instance 4

Elapsed time is 31m:59s:227ms for server 1, instance 8

Elapsed time is 32m:2s:159ms for server 1, instance 6

Elapsed time is 32m:13s:9ms for server 1, instance 2

Elapsed time is 32m:10s:432ms for server 1, instance 5

Elapsed time is 32m:9s:90ms for server 1, instance 10

Elapsed time is 32m:16s:71ms for server 1, instance 9

Elapsed time is 32m:20s:113ms for server 1, instance 7


9 instances

Elapsed time is 37m:22s:246ms for server 1, instance 2

Elapsed time is 37m:27s:455ms for server 1, instance 8

Elapsed time is 37m:34s:342ms for server 1, instance 9

Elapsed time is 37m:39s:948ms for server 1, instance 4

Elapsed time is 37m:38s:118ms for server 1, instance 6

Elapsed time is 37m:40s:729ms for server 1, instance 5

Elapsed time is 37m:44s:4ms for server 1, instance 3

Elapsed time is 37m:40s:121ms for server 1, instance 7

Elapsed time is 37m:46s:333ms for server 1, instance 1


9 instances

Elapsed time is 32m:3s:246ms for server 1, instance 3

Elapsed time is 32m:4s:702ms for server 1, instance 4

Elapsed time is 32m:9s:373ms for server 1, instance 2

Elapsed time is 32m:13s:377ms for server 1, instance 7

Elapsed time is 32m:19s:748ms for server 1, instance 1

Elapsed time is 32m:11s:744ms for server 1, instance 9

Elapsed time is 32m:13s:454ms for server 1, instance 8

Elapsed time is 32m:19s:453ms for server 1, instance 5

Elapsed time is 32m:23s:485ms for server 1, instance 6


8 instances

Elapsed time is 37m:29s:733ms for server 1, instance 6

Elapsed time is 37m:36s:163ms for server 1, instance 1

Elapsed time is 37m:38s:562ms for server 1, instance 4

Elapsed time is 37m:35s:292ms for server 1, instance 8

Elapsed time is 37m:37s:848ms for server 1, instance 7

Elapsed time is 37m:43s:331ms for server 1, instance 5

Elapsed time is 37m:51s:599ms for server 1, instance 3

Elapsed time is 37m:55s:357ms for server 1, instance 2


8 instances

Elapsed time is 32m:16s:530ms for server 1, instance 4

Elapsed time is 32m:18s:186ms for server 1, instance 3

Elapsed time is 32m:20s:448ms for server 1, instance 1

Elapsed time is 32m:15s:947ms for server 1, instance 7

Elapsed time is 32m:19s:975ms for server 1, instance 6

Elapsed time is 32m:25s:209ms for server 1, instance 2

Elapsed time is 32m:25s:648ms for server 1, instance 5

Elapsed time is 32m:24s:297ms for server 1, instance 8


7 instances

Elapsed time is 40m:58s:739ms for server 1, instance 4

Elapsed time is 40m:58s:907ms for server 1, instance 5

Elapsed time is 41m:0s:193ms for server 1, instance 6

Elapsed time is 41m:5s:209ms for server 1, instance 2

Elapsed time is 41m:8s:247ms for server 1, instance 1

Elapsed time is 41m:7s:873ms for server 1, instance 3

Elapsed time is 41m:6s:759ms for server 1, instance 7


7 instances

Elapsed time is 34m:39s:463ms for server 1, instance 5

Elapsed time is 34m:40s:872ms for server 1, instance 4

Elapsed time is 34m:46s:214ms for server 1, instance 1

Elapsed time is 34m:40s:261ms for server 1, instance 7

Elapsed time is 34m:48s:37ms for server 1, instance 2

Elapsed time is 34m:48s:895ms for server 1, instance 3

Elapsed time is 34m:46s:321ms for server 1, instance 6


6 instances

Elapsed time is 46m:34s:801ms for server 1, instance 6

Elapsed time is 46m:37s:638ms for server 1, instance 4

Elapsed time is 46m:48s:65ms for server 1, instance 3

Elapsed time is 46m:50s:763ms for server 1, instance 2

Elapsed time is 46m:50s:857ms for server 1, instance 5

Elapsed time is 46m:59s:10ms for server 1, instance 1


6 instances

Elapsed time is 39m:39s:83ms for server 1, instance 4

Elapsed time is 39m:38s:18ms for server 1, instance 6

Elapsed time is 39m:42s:802ms for server 1, instance 2

Elapsed time is 39m:47s:786ms for server 1, instance 1

Elapsed time is 39m:45s:923ms for server 1, instance 5

Elapsed time is 39m:54s:210ms for server 1, instance 3


5 instances

Elapsed time is 53m:18s:539ms for server 1, instance 4

Elapsed time is 53m:19s:552ms for server 1, instance 3

Elapsed time is 53m:37s:537ms for server 1, instance 1

Elapsed time is 53m:35s:714ms for server 1, instance 5

Elapsed time is 53m:39s:807ms for server 1, instance 2


5 instances

Elapsed time is 45m:43s:126ms for server 1, instance 5

Elapsed time is 45m:59s:761ms for server 1, instance 1

Elapsed time is 45m:59s:664ms for server 1, instance 2

Elapsed time is 46m:1s:887ms for server 1, instance 3

Elapsed time is 46m:3s:482ms for server 1, instance 4


4 instances

Elapsed time is 1h:5m:26s:931ms for server 1, instance 1

Elapsed time is 1h:5m:32s:97ms for server 1, instance 2

Elapsed time is 1h:5m:40s:689ms for server 1, instance 4

Elapsed time is 1h:5m:43s:715ms for server 1, instance 3


4 instances

Elapsed time is 53m:58s:125ms for server 1, instance 1

Elapsed time is 53m:57s:353ms for server 1, instance 4

Elapsed time is 54m:1s:919ms for server 1, instance 3

Elapsed time is 54m:10s:486ms for server 1, instance 2


3 instances

Elapsed time is 1h:23m:11s:924ms for server 1, instance 3

Elapsed time is 1h:23m:17s:459ms for server 1, instance 1

Elapsed time is 1h:23m:20s:14ms for server 1, instance 2


3 instances

Elapsed time is 1h:8m:23s:528ms for server 1, instance 2

Elapsed time is 1h:8m:26s:741ms for server 1, instance 3

Elapsed time is 1h:8m:28s:123ms for server 1, instance 1


2 instances

Elapsed time is 1h:59m:58s:396ms for server 1, instance 2

Elapsed time is 2h:0m:6s:55ms for server 1, instance 1


2 instances

Elapsed time is 1h:37m:49s:391ms for server 1, instance 2

Elapsed time is 1h:37m:54s:250ms for server 1, instance 1


1 instance

Elapsed time is 3h:44m:17s:53ms for server 1, instance 1

1 instance
Elapsed time is 3h:3m:21s:241ms for server 1, instance 1