I’m trying to use sample flights database 7M, 14M, 21M and 117M records.
I checked the response time for each of CPU mode and GPU mode.
My results showed that CPU mode got a little faster with all datasets.
I think that this result was caused my GPU’s spec is not good, right?
It’s better to think upgrade the GPU ?
Or I have to do some tuning for MapD ?
select avg(arrdelay), origin_city from flights_nM group by origin_city;
Response time (msec)
| DB records | CPU mode | GPU mode | | | 1st time | 2nd time | 1st time | 2nd time | | 7M | 1,619 | 53 | 1,701 | 112 | | 14M | 1,662 | 70 | 1,805 | 190 | | 21M | 1,718 | 82 | 1,934 | 265 | | 117M | 2,684 | 235 | 3,548 | 1,150 |
Xeon E5-2620 (6core) ×2
NVIDIA NVS 510
NVIDIA Kepler™ GPU
CUDA 192 Cores
GPU Memory 2.0 GB DDR3
Memory Interface 128-bit
Memory Bandwidth 28.5 GB/sec
fragment size = 2M, database is on HDD (RAID10).