Benchmark: State Key Creation (With Preparation Code)

State Key Creation (With Preparation Code) (version: 2)

my test benchmark

Comparing performance of: `Nested Join + Join (Join x3) vs Loop Push + Join (Join x1 with string) vs Simple Join (Join x1 with arrays) vs Loop Concatenate (string only) vs Template Literal (template literal string with arrays) vs Template Literal + Join (template literal string with join) vs Simple Concatenate + Join`

Created: 9 months ago by: Registered User

Go to the latest result

Script Preparation code:

const usableCount = 5;
const itemCount = 10;

const type = Math.floor(Math.random() * 100);
const usables = new Array(usableCount).fill(0).map(_ => Math.floor(Math.random() * 100));
const items = new Array(itemCount).fill(0).map(_ => Math.floor(Math.random() * 100));

Tests:

Nested Join + Join (Join x3)
const key = [type, usables.join(), items.join()].join ("|");
Loop Push + Join (Join x1 with string)
let data = [type, "|"]; const usableCountMinusOne = usableCount - 1; for (let i = 0 ; i < usableCountMinusOne ; i++) data.push (usables[i], ","); data.push (usables[usableCountMinusOne], "|"); const itemCountMinusOne = itemCount - 1; for (let i = 0 ; i < itemCountMinusOne ; i++) data.push (items[i], ","); data.push (items[itemCountMinusOne]); const key = data.join ("");
Simple Join (Join x1 with arrays)
const key = [type, usables, items].join ("|");
Loop Concatenate (string only)
let key = type + "|"; const usableCountMinusOne = usableCount - 1; for (let i = 0 ; i < usableCountMinusOne ; i++) key += usables[i] + ","; key += usables[9] + "|"; const itemCountMinusOne = itemCount - 1; for (let i = 0 ; i < itemCountMinusOne ; i++) key += items[i] + ","; key += items[9];
Template Literal (template literal string with arrays)
const key = `${type}|${usables}|${items}`;
Template Literal + Join (template literal string with join)
const key = `${type}|${usables.join()}|${items.join}`;
Simple Concatenate + Join
const key = type + "|" + usables.join() + "|" + items.join();

Historical Performance Data aggregated from 1,715 community runs

Desktop Results:

Chrome 1,715 runs

MmzHrrdb

1/s

-1 OR 5*5=25 --

1/s

-1 OR 5*5=25

1/s

-1' OR 5*5=25 --

1/s

-1" OR 5*5=25 --

1/s

if(now()=sysdate(),sleep(15),0)

1/s

MmzHrrdb0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z

1/s

MmzHrrdb0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z

1/s

(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/

1/s

MmzHrrdb-1; waitfor delay '0:0:15' --

1/s

MmzHrrdb-1); waitfor delay '0:0:15' --

1/s

MmzHrrdb-1 waitfor delay '0:0:15' --

1/s

MmzHrrdb'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'

1/s

MmzHrrdb'"

1/s

MmzHrrdb%C0%A7%C0%A2%2527%2522\'\"

1/s

(select 198766*667891)

1/s

(select 198766*667891 from DUAL)

1/s

View exact numbers

✓ MmzHrrdb: 1 ops/sec
• -1 OR 5*5=25 -- : 1 ops/sec
• -1 OR 5*5=25: 1 ops/sec
• -1' OR 5*5=25 -- : 1 ops/sec
• -1" OR 5*5=25 -- : 1 ops/sec
• if(now()=sysdate(),sleep(15),0): 1 ops/sec
• MmzHrrdb0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z: 1 ops/sec
• MmzHrrdb0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z: 1 ops/sec
• (select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/: 1 ops/sec
• MmzHrrdb-1; waitfor delay '0:0:15' -- : 1 ops/sec
• MmzHrrdb-1); waitfor delay '0:0:15' -- : 1 ops/sec
• MmzHrrdb-1 waitfor delay '0:0:15' -- : 1 ops/sec
• MmzHrrdb'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||': 1 ops/sec
• MmzHrrdb'": 1 ops/sec
• MmzHrrdb%C0%A7%C0%A2%2527%2522\'\": 1 ops/sec
• (select 198766*667891): 1 ops/sec
• (select 198766*667891 from DUAL): 1 ops/sec

Results show median performance across all community submissions. Run this benchmark yourself to verify on your device.

Rendered benchmark preparation results:

Suite status: <idle, ready to run>

Previous results

Test case name	Result
Nested Join + Join (Join x3)
Loop Push + Join (Join x1 with string)
Simple Join (Join x1 with arrays)
Loop Concatenate (string only)
Template Literal (template literal string with arrays)
Template Literal + Join (template literal string with join)
Simple Concatenate + Join

Fastest: N/A

Slowest: N/A

Latest run results:

Run details: (Test run date: one month ago)

User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36

Browser/OS: Chrome 141 on Windows

View result in a separate tab

MmzHrrdb

1/s

MmzHrrdb

1/s

MmzHrrdb

1/s

MmzHrrdb

1/s

MmzHrrdb

1/s

MmzHrrdb

1/s

MmzHrrdb

1/s

View exact numbers

Test name	Executions per second
✓ MmzHrrdb	1 Ops/sec
✓ MmzHrrdb	1 Ops/sec
✓ MmzHrrdb	1 Ops/sec
✓ MmzHrrdb	1 Ops/sec
✓ MmzHrrdb	1 Ops/sec
✓ MmzHrrdb	1 Ops/sec
✓ MmzHrrdb	1 Ops/sec

State Key Creation (With Preparation Code) (version: 2)

my test benchmark

Created: 9 months ago by: Registered User

Go to the latest result

Nested Join + Join (Join x3)

Loop Push + Join (Join x1 with string)

Simple Join (Join x1 with arrays)

Loop Concatenate (string only)

Template Literal (template literal string with arrays)

Template Literal + Join (template literal string with join)

Simple Concatenate + Join

Historical Performance Data aggregated from 1,715 community runs

Desktop Results:

Chrome 1,715 runs

Suite status: <idle, ready to run>

Fastest: N/A

Slowest: N/A

Related benchmarks