Implement full text search #153

New issue

Open

opened 2015-04-04 16:14:21 +00:00 by GoogleCodeExporter · 1 comment

GoogleCodeExporter commented

2015-04-04 16:14:21 +00:00

(Migrated from github.com)

Currently, searching for stories and comments is awfully slow. No surprise, 
`like` searches never perform very well for larger databases.

Full text table are not supported with InnoDB and MySQL <5.6, so at least for 
Antville.org we either need to step back to MyISAM (meh) or upgrade to 5.6.

Another option would be ElasticSearch.

Anyway, for the time being I added support for using Google’s custom search 
in the compatibility layer. Using the layer it can be enabled by setting 
google-search = true in app.properties

Original issue reported on code.google.com by m...@tobischaefer.com on 6 Jan 2015 at 5:56

``` Currently, searching for stories and comments is awfully slow. No surprise, `like` searches never perform very well for larger databases. Full text table are not supported with InnoDB and MySQL <5.6, so at least for Antville.org we either need to step back to MyISAM (meh) or upgrade to 5.6. Another option would be ElasticSearch. Anyway, for the time being I added support for using Google’s custom search in the compatibility layer. Using the layer it can be enabled by setting google-search = true in app.properties ``` Original issue reported on code.google.com by `m...@tobischaefer.com` on 6 Jan 2015 at 5:56

github-actions[bot] commented

2021-05-17 02:38:19 +00:00

(Migrated from github.com)

Stale issue message