SQL Server全文索引如何增长？
我试图了解全文索引的增长并评估其长期内存需求。
它会保留每次搜索的缓存吗？ （知道第一次搜索新关键字总是需要稍长的时间，随后会更快）它会无限增长吗？
或者它的大小在创建后就几乎是有限的？
随着时间的推移，我应该预期性能会下降、停滞还是改善？
I'm trying to get an idea of fulltext index growth and gauge its long-term memory needs.
Does it keep a cache of each search? (Knowing that the first search for a new keywords always takes slightly longer, and is subsequently faster) Will it grow indefinitely?
Or is its size pretty much finite after its creation?
Should I expect performance degradation, stagnation, or improvement over time?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
一般来说，FT 目录将随着索引文档的数量成比例增长。 FT 索引的缓存属于 SQL Server 缓冲池缓存的一般类别。
查看大型目录的 SQL Server 2005 全文查询：经验教训< /a>
但请注意，SQL 2005 和 SQL 2008 之间的 FT 性能有显着变化。
As a general rule, a FT catalog will grow proportionally with the number of documents indexed. Caching of FT indexes falls under the general category of SQL Server buffer pool caching.
Have a look at SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned
Note though that there are significant changes in FT performance between SQL 2005 and SQL 2008.