paleolimbot commented on PR #24:
URL: https://github.com/apache/sedona-db/pull/24#issuecomment-3259089548
I don't see any issues running these without the benchmark suite:
```python
from sedonadb.testing import SedonaDB, DuckDB
sedonadb = SedonaDB()
duckdb = DuckDB()
random = sedonadb.con.sql("""
SELECT geometry FROM sd_random_geometry('{
"geom_type": "Point",
"target_rows": 10000000,
"vertices_per_linestring_range": [2, 2]
}')""")
duckdb.create_table_arrow("random", random)
sedonadb.create_table_arrow("random", random)
%time duckdb.execute_and_collect("SELECT ST_Buffer(geometry, 0.1) FROM
random")
#> CPU times: user 1min 20s, sys: 2.04 s, total: 1min 22s
#> Wall time: 7.53 s
%time sedonadb.execute_and_collect("SELECT ST_Buffer(geometry, 0.1) FROM
random")
#> CPU times: user 1min 31s, sys: 3.05 s, total: 1min 35s
#> Wall time: 9.75 s
```
Maybe `duckdb` always runs single threaded under `pytest`? Probably it makes
sense to roll our own benchmark suite.
--
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]
