Viewing profile — jschafer

Yes exactly, I was really excited when I found out that you do not need a FFT to do speech processing. If you look at the code of (phone/voice) codecs GSM/Speex/Opus you can see th…

SQLite only knows nested loop joins and the bloom filter can just tell us "no need to do a join, there is definitely no matching entry". If it has a false positive all the time (th…

I do not know if it is still the case, but the last time I looked into the source code SQLite did hash all strings to the exact same value. So the bloom filter optimization does no…

Note that the measurements in the paper were made before they fixed a bug where they confused bits and bytes. So SQLite only used 1/8 of the reserved bloom filter space, thus incre…