3 ms·
Anyone have a sense for the kinds of queries this would actually help with?
by javajosh 11y ago
Anyone have a sense for the kinds of queries this would actually help with?
- pcwalton 11y agoProbably queries that have a lot of brute-force comparisons involving full table scans. "select foo from bar where baz > 30" with no index, for example. (Source: I've done a fair bit of experimentation in GPU queries in the domain of CSS selector matching.)
- radiowave 11y agoInteresting thought. I was assuming that the impressive performance figures based on joining 10 tables together would be making use of indexes, because with full table scans it might be difficult to keep the GPUs fed with data.
- jessedhillon 11y agoIn the article linked, they show a multi-way join on integer keys, which is able to leverage accelerated integer comparison (presumably.) I'd imagine a whole range of GIS queries also have the potential to be sped up by GPU offloading.