Full-text search

Question

The time has come to make it happen. I've started the research and playing around already.

该提问来源于开源项目：vladimiry/ElectronMail

Answer 1

I tried to keep the search index close to the database but it's not going to work well since the index is 3-5x times bigger than the database itself. So the full database serialization takes time, besides the main process might get blocked by expensive serialization/indexing/search actions. So going to try maintaining all the expensive indexing operations in a separate process and save the index in an individual encrypted file like database-index.bin.