<p data-line="0" class="code-line">ElasticsearchやOpenSearchを出し抜く全文検索エンジンを検討したら、SQLite3のFTS5を直列的に並べるという構造に行き着いた。<br>
<img src="https://storage.googleapis.com/zenn-user-upload/7e554c4b07a4-20260126.png" alt="" class="md-img" loading="lazy"></p>
<p data-line="3" class="code-line"><span class="embed-block zenn-embedded zenn-embedded-card"><iframe id="zenn-embedded__d21fa17dddb46" src="https://embed.zenn.studio/card#zenn-embedded__d21fa17dddb46" data-content="https%3A%2F%2Fmikio.hatenablog.com%2Fentry%2F2026%2F01%2F26%2F004436" frameborder="0" scrolling="no" loading="lazy"></iframe></span><a href="https://mikio.hatenablog.com/entry/2026/01/26/004436" style="display:none" target="_blank" rel="nofollow noopener noreferrer">https://mikio.hatenablog.com/entry/2026/01/26/004436</a></p>


3TS: SNS用の超低コスト全文検索アーキテクチャ

Discussion