To see the performance difference of running on GPU over CPU, manually switch where your queries are run:
- Enable timing reporting in
heavysql
using\timing
- Ensure that you are in GPU mode (the default):
\gpu
- Run your queries a few times. Because data is lazily moved to the GPUs, the first time you query new data/columns takes a bit longer than subsequent times.
- Switch to CPU mode:
\cpu
. Again, run your queries a few times - Observe the differences
If you are using a data set that large, you should see a significant difference between the two. However, if the sample set is relatively small (for example, the sample 7-million flights dataset that comes preloaded in OmniSci) some of the fixed overhead of running on the GPUs causes those queries to appear to run slower than on the CPU.
Comments
0 comments
Article is closed for comments.