alamb commented on issue #17721: URL: https://github.com/apache/datafusion/issues/17721#issuecomment-3503829497
My manual results are consistent with my local timings -- 47 takes around 9.8 seconds for Q23 and 50 takes around 8.5 seconds. # Flushing caches: sync echo 3 | sudo tee /proc/sys/vm/drop_caches >/dev/null # run in loop 5 times: for i in `seq 1 5` ; do ~/datafusion-50/target/release/datafusion-cli -f create.sql q23.sql | grep Elapsed ; done ``` Elapsed 0.131 seconds. Elapsed 106.409 seconds. Elapsed 0.041 seconds. Elapsed 8.568 seconds. Elapsed 0.041 seconds. Elapsed 8.407 seconds. Elapsed 0.041 seconds. Elapsed 8.697 seconds. Elapsed 0.041 seconds. Elapsed 8.546 seconds. ``` Now with datafusion 47 ```shell # Flushing caches: sync echo 3 | sudo tee /proc/sys/vm/drop_caches >/dev/null # run in loop 5 times: for i in `seq 1 5` ; do ~/datafusion-47/target/release/datafusion-cli -f create.sql q23.sql | grep Elapsed ; done ``` Elapsed 0.103 seconds. Elapsed 111.752 seconds. Elapsed 0.039 seconds. Elapsed 9.922 seconds. Elapsed 0.040 seconds. Elapsed 9.869 seconds. Elapsed 0.040 seconds. Elapsed 9.804 seconds. Elapsed 0.040 seconds. Elapsed 9.858 seconds. I am going to try and rebuild the binaries a little differently and see if that makes a difference -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
