Kontinuation commented on PR #24:
URL: https://github.com/apache/sedona-db/pull/24#issuecomment-3258576653
I was using my local build of duckdb-spatial using the latest trunk, the
duckdb-python is also built using my locally built latest 1.4.1-dev version.
I have tried re-installing duckdb using `pip install duckdb --upgrade --pre`
and ran another benchmark (test_st_buffer), the behavior is basically the same:
```
-----------------------------------------------------------------------------------
benchmark 'table=collections_complex': 2 tests
----------------------------------------------------------------------------------
Name (time in ms) Min
Max Mean StdDev Median
IQR Outliers OPS Rounds Iterations
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
test_st_buffer[collections_complex-SedonaDB] 115.0520 (1.0)
157.6825 (1.0) 128.0455 (1.0) 13.9384 (1.73) 122.8113 (1.0)
10.1471 (1.0) 2;1 7.8097 (1.0) 9 1
test_st_buffer[collections_complex-DuckDB] 611.7650 (5.32)
633.0960 (4.02) 623.6101 (4.87) 8.0625 (1.0) 623.5183 (5.08)
10.8149 (1.07) 2;0 1.6036 (0.21) 5 1
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------
benchmark 'table=collections_simple': 2 tests
-----------------------------------------------------------------------------------
Name (time in ms) Min Max
Mean StdDev Median IQR
Outliers OPS Rounds Iterations
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
test_st_buffer[collections_simple-SedonaDB] 111.6307 (1.0) 128.6885
(1.0) 120.1398 (1.0) 5.7616 (1.0) 121.7260 (1.0) 8.5031
(1.0) 3;0 8.3236 (1.0) 9 1
test_st_buffer[collections_simple-DuckDB] 619.3594 (5.55) 698.7082
(5.43) 655.4287 (5.46) 34.3422 (5.96) 657.1137 (5.40) 60.9305
(7.17) 2;0 1.5257 (0.18) 5 1
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
