Difference between #5 and #6 of
Creating a parameterized LIKE query

Revision #6 has been created by Asgaroth on Nov 15, 2011, 2:36:42 AM with the memo:

Added solr link
« previous (#5)

Changes

Title unchanged

Creating a parameterized LIKE query

Category unchanged

FAQs

Yii version unchanged

Tags unchanged

LIKE, substring query

Content changed

[...]
* This is not scalable and can be really slow on medium-sized databases.
For instance, MySQL cannot use indexes with such criteria, so it has to process the whole data.
* This is not a *google-like* search, and complex queries like `zend -framework "php core"` are not possible. Users often expect more than just a substring search.

While both Postgresql and MySQL include an embedded full-text search, this kind of search is often handled by another service. The most well-known free systems are Xapian, Sphinx and Lucene.
For instance, the [DGSphinxSearch Extension](http://www.yiiframework.com/extension/dgsphinxsearch) shows how to integrate [Sphinx Search](http://sphinxsearch.com/) into Yii.
 
There are already some yii extensions for this:
 
 
- [**Sphinx**](http://sphinxsearch.com/) : [DGSphinxSearch Extension](http://www.yiiframework.com/extension/dgsphinxsearch)
 
- [**Solr (Lucene)**](http://lucene.apache.org/solr/) : [Solr Extension](http://www.yiiframework.com/extension/solr/)
 
 
13 0
21 followers
Viewed: 144 658 times
Version: 1.1
Category: FAQs
Tags: LIKE, substring query
Written by: Steve Friedl
Last updated by: Asgaroth
Created on: May 29, 2011
Last updated: 13 years ago
Update Article
Revert to #5 | Revert to #6

Revisions

View all history