搜索记录是最好的serach技术 [英] Which is best serach technique to search records
问题描述
我有10,000,000条记录,这将是搜索记录的最佳技术,目前即时通讯使用全文搜索,但速度很慢,请提出建议。 / div>
没有一成不变的解决方案,但您可以尝试:
Sphinx
您如何为该1000万行表执行全文搜索
,使用加载保持
,然后停留有关?
Sphinx善于使用这些类型的
谜语。
Sphinx是一个全文搜索引擎,在GPL版本2下分发
。
商业授权也可用于嵌入式使用
。
通常,它是一个独立的搜索
引擎,旨在提供快速,
规模效率和相关全文
搜索功能到其他
应用程序。 Sphinx特别是
,旨在与SQL
数据库和脚本语言很好地集成。
当前内置的数据源
支持通过
直接连接到MySQL或
获取数据PostgreSQL或使用XML管道
机制(管道到索引器在
特殊的基于XML的格式,Sphinx
可以识别)。
至于名称,Sphinx是首字母缩写
,它被正式解码为SQL
短语索引。是的,我知道CMU的
Sphinx项目。
Lucene PHP Zend Framework):
Zend_Search_Lucene是一个通用的
目的文本搜索引擎完全在PHP 5中编写
。由于它在文件系统上存储
索引,并且
不需要数据库服务器,因此可以将
搜索功能添加到几乎任何
PHP驱动的网站。 Zend_Search_Lucene
支持以下功能:
- 许多强大的查询类型:短语查询,布尔查询,通配符
查询,近距离查询,范围
查询和其他许多查询。特定字段(例如,标题,作者,内容)
http://framework.zend.com/
http://framework.zend.com/manual/en/zend.search.lucene.overview.html
I have 10,000,000 records which will be the best technique to search records, currently i m using full text search but it is slow,please suggest.
There is no one-size-fits-all solution but you can try out:
Sphinx
How do you implement full-text search for that 10+ million row table, keep up with the load, and stay relevant? Sphinx is good at those kinds of riddles.
Sphinx is a full-text search engine, distributed under GPL version 2. Commercial license is also available for embedded use.
Generally, it's a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).
As for the name, Sphinx is an acronym which is officially decoded as SQL Phrase Index. Yes, I know about CMU's Sphinx project.
Lucene PHP (Part of Zend Framework):
Zend_Search_Lucene is a general purpose text search engine written entirely in PHP 5. Since it stores its index on the filesystem and does not require a database server, it can add search capabilities to almost any PHP-driven website. Zend_Search_Lucene supports the following features:
- Ranked searching - best results returned first
- Many powerful query types: phrase queries, boolean queries, wildcard
queries, proximity queries, range
queries and many others.- Search by specific field (e.g., title, author, contents)
http://framework.zend.com/ http://framework.zend.com/manual/en/zend.search.lucene.overview.html
这篇关于搜索记录是最好的serach技术的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!