java - 请问大家如何利用lucence等搜索引擎优化mysql数据库查询？

Question

想了解下大家是在何种场景或数据量的情况下会使用搜索引擎来优化数据库查询？如何同步搜索引擎的索引和数据库的数据？

Answer 1

For example, full-text search, scenario 1: Search matching stores based on the input Chinese. For synchronization, you can adopt different synchronization plans based on your acceptance of consistency, such as full synchronization at night, real-time incremental synchronization, etc.

Answer 2

Lucene is a text search engine, why is it related to database optimization query?