3 ms·
This is really cool, but something doesn't smell right. 1) They give numbers from a single-core CPU implementation, and from a many-core GPU implementation, an
by lsb 17y ago
This is really cool, but something doesn't smell right.
1) They give numbers from a single-core CPU implementation, and from a many-core GPU implementation, and they discuss numbers from a many-core CPU implementation as well, like some of the new four- or eight-core chips; without many-core CPU numbers, it's comparing apples to oranges.
2) What indices are on the table? Does the GPU have any indices? A read-only database is certainly going to have indices, and (hopefully) covering indices for all the big queries.
3) SQLite has strongly-typed values not columns (you can stick a string in an integer column and that's just fine) and it seems like they disregarded much of the SQLite type system, only focusing on integer values. I'd like to know how much time is spent on type checking values.