SQLite Forum

Any use case for the Bloom filter for "large analytic queries"
Login
I have just such a case, but I have a rather large query, it first selects from virtual tables, and then left joins the sqlite table merged 9 times with different join options. The bloom filter is calculated for the tables that have passed through 7 times. As a result, the speed drops from 22ms to 250ms.

The query text is not very important, I can't reproduce this behavior without my virtual tables, and when the query is simplified, the bloom filter is turned off and the execution speed returns to normal.

The question is the following: will it be possible to disable the bloom filter, similar to disabling the use of an index using "+".
Perhaps "*" or "++" or using a pragma?