JingsongLi commented on PR #6028:
URL: https://github.com/apache/paimon/pull/6028#issuecomment-3178989361
> After #6060.
>
> This is the Top1 benchmark based on the range-bitmap file index.
>
> ```
> Running benchmark: topn
> Running case: without-index-300-1
> Stopped after 1 iterations, 502 ms
> Running case: with-index-300-1
> Stopped after 1 iterations, 20 ms
>
> OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6
> Apple M4 Pro
> topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
> OPERATORTEST_topn_without-index-300-1
502 / 502 1991.7 502.1
1.0X
> OPERATORTEST_topn_with-index-300-1
21 / 21 48223.6 20.7
24.2X
>
>
>
>
> Running benchmark: topn
> Running case: without-index-3000-1
> Stopped after 1 iterations, 483 ms
> Running case: with-index-3000-1
> Stopped after 1 iterations, 19 ms
>
> OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6
> Apple M4 Pro
> topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
> OPERATORTEST_topn_without-index-3000-1
484 / 484 2066.9 483.8
1.0X
> OPERATORTEST_topn_with-index-3000-1
20 / 20 50313.5 19.9
24.3X
>
>
>
>
> Running benchmark: topn
> Running case: without-index-30000-1
> Stopped after 1 iterations, 495 ms
> Running case: with-index-30000-1
> Stopped after 1 iterations, 18 ms
>
> OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6
> Apple M4 Pro
> topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
> OPERATORTEST_topn_without-index-30000-1
496 / 496 2016.4 495.9
1.0X
> OPERATORTEST_topn_with-index-30000-1
19 / 19 53724.8 18.6
26.6X
>
>
>
>
> Running benchmark: topn
> Running case: without-index-300000-1
> Stopped after 1 iterations, 511 ms
> Running case: with-index-300000-1
> Stopped after 1 iterations, 19 ms
>
> OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6
> Apple M4 Pro
> topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
> OPERATORTEST_topn_without-index-300000-1
512 / 512 1953.7 511.8
1.0X
> OPERATORTEST_topn_with-index-300000-1
19 / 19 52073.4 19.2
26.7X
>
>
>
>
> Running benchmark: topn
> Running case: without-index-3000000-1
> Stopped after 1 iterations, 516 ms
> Running case: with-index-3000000-1
> Stopped after 1 iterations, 19 ms
>
> OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6
> Apple M4 Pro
> topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
> OPERATORTEST_topn_without-index-3000000-1
517 / 517 1935.1 516.8
1.0X
> OPERATORTEST_topn_with-index-3000000-1
19 / 19 52186.5 19.2
27.0X
> ```
This result looks amazing!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@paimon.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
