SQLite Forum

Any use case for the Bloom filter for "large analytic queries"
Login
> I haven't yet run across a case where the query planner adds a Bloom filter which ends up slowing things down. But that doesn't mean no such case exists.

I read sometime ago ( I believe on cloudflare blog) that if Bloom filter doesn't fit in L3 CPU cache then it became slow due to overhead to accessing "slow" RAM randomly. 

P.S.
Found link: https://blog.cloudflare.com/when-bloom-filters-dont-bloom/