4 ms·
I have often wondered if you couldn't put the needed database indexes and other associated data onto a GPU , and have the GPU handle the optimization for the qu
by patrickgzill 16y ago
I have often wondered if you couldn't put the needed database indexes and other associated data onto a GPU , and have the GPU handle the optimization for the query, run the query, and then just return to the database server which blocks to go to to get the data; the indexes could be synced to disk of course but they would be run from the GPU.
- nl 16y agoThere's a paper by some people who got MySQL to sort using the GPU, and got great speedup. That was quite old and I can't find it now. However, a more recent paper is Accelerating SQL Database Operations on a GPU with CUDA: http://www.cs.virginia.edu/~skadron/Papers/bakkum_sqlite_gpgpu10.pdf http://www.cs.virginia.edu/~skadron/Papers/bakkum_sqlite_gpg... The references in that paper are pretty interesting, too.
- lsb 16y agoThat looks pretty cool, and the best performance seems to come from aggregating and doing floating point math. SQLite is designed for embedding into cell phones and web browsers and other tiny devices, so I'd expect that there's quite a bit of room for optimizing the floating point math on server-grade hardware.