如何创建高效的自动完成？
我想实施“文本”建议。
我有大量数据，如何实现高效且可扩展的自动完成？
编辑1： 我有一个 mysql 表，每行一个客户端和一个“名称”列，我想创建一个建议来搜索客户端名称（如谷歌建议，但不是查询，而是客户端名称）-我有大量行，如何设计有效的建议？
当用户开始在“输入文本”中输入时，我想显示可能的客户端名称
I want to implement a "text" suggestion.
I have a huge number of data, how I can implement an efficient and scalable auto-complete?
Edit 1:
i have a mysql table with one client per row and a 'name' column, i want to create a suggest in order to search client name (like google suggest but instead of queries it is client name) - I have a huge numbers of rows, how I can design an efficient suggest?
When user will start typing inside an "input text", I want to display possible client names
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
好的，我想我明白您在寻找什么，这里有一些可能的解决方案适合您：
从本质上讲，您似乎是寻找自动完成功能（如果我正确理解你的问题）。沿着这些思路，上述问题及其答案也为如何提出更复杂的建议（即基于内容、语义、意图等）提供了大量参考。
如果您正在寻找一种提出“相关”建议的算法，这可能无法解决您的问题，例如：
OK, I think I understand what you're looking for and here are some possible solutions for you:
Essentially, it seems like you're looking for auto-complete functionality (if I understood your question correctly). Along those lines, the above questions and their answers also provide a lot of references on how to do more complex suggestions (i.e. based on content, semantics, intent, etc.).
This will probably not address your question if you're looking for an algorithm that makes "related" suggestions, e.g.: