Sorry for the suspense last night, my code is very slow; I will jump into #foundationdb instead of #sqlite's LSM extension which can't work with parallel threads for some reason. Maybe the problem is somewhere else... anyway the target is foundationdb not sqlite, so let it be.
PS: The search engine work and give sensible results but it is very slow more than 15 seconds for some queries which is not acceptable.