On 4/3/19, Joshua Wise <[email protected]> wrote: > From my naive understanding, memcmp() is used to efficiently compare long > strings of bytes. But where in SQLite3 is it necessary to compare long > strings of floating point numbers? I, of course, can imagine SQL queries > plucking single floating point values from rows or indexes, but I can’t > imagine where the long strings would be. Could you enlighten me?
Comparing keys in a btree search uses a lot of CPU cycles. If the comparison can be done using memcmp() rather than some custom function, the comparison goes much faster, which makes searching btrees faster. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
