pwrliang commented on PR #465: URL: https://github.com/apache/sedona-db/pull/465#issuecomment-3775921519
Here's the evaluation result from [a *variant* of Sedona-SpatialBench](https://github.com/pwrliang/sedona-bench) Each query was executed 5 times with one round of warmup to cache datasets in buff/cache, and the average times are reported. Using GPU join is faster for queries with heavy joins, such as Q10 and Q11. Commit: https://github.com/apache/sedona-db/pull/465/commits/b690b127a626daf51b350deaf99f3234f22851f5 Machine: AWS g5.2xlarge (NVIDIA A10) | Mode | Scale Factor | Query | Time (s) | | :--- | :--- | :--- | :--- | | gpu | sf_1 | q2 | 4.721 | | gpu | sf_1 | q4 | 1.293 | | gpu | sf_1 | q8 | 0.413 | | gpu | sf_1 | q9 | 0.041 | | gpu | sf_1 | q10 | 4.396 | | gpu | sf_1 | q11 | 6.773 | | gpu | sf_10 | q2 | 8.036 | | gpu | sf_10 | q4 | 2.01 | | gpu | sf_10 | q8 | 1.78 | | gpu | sf_10 | q9 | 0.144 | | gpu | sf_10 | q10 | 9.092 | | gpu | sf_10 | q11 | 17.378 | Commit: https://github.com/apache/sedona-db/commit/e106ce65b6ded198298c36d87776dae878c88282 Machine: m7i.2xlarge | Mode | Scale Factor | Query | Time (s) | | :--- | :--- | :--- | :--- | | cpu | sf_1 | q2 | 4.732 | | cpu | sf_1 | q4 | 0.742 | | cpu | sf_1 | q8 | 0.489 | | cpu | sf_1 | q9 | 0.021 | | cpu | sf_1 | q10 | 5.126 | | cpu | sf_1 | q11 | 8.625 | | cpu | sf_10 | q2 | 31.165 | | cpu | sf_10 | q4 | 1.249 | | cpu | sf_10 | q8 | 4.53 | | cpu | sf_10 | q9 | 0.062 | | cpu | sf_10 | q10 | 28.368 | | cpu | sf_10 | q11 | 44.737 | -- 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]
