http://www.flickr.com/photos/mamarazzi/5301553054/http://www.flickr.com/photos/mamarazzi/5301553054/

Volltextsuche im VergleichVolltextsuche im Vergleich

Walter EbertWalter Ebert

Suchblog@suchblog

suchblog.infosearchmeetupfrankfurt.de

Walter Ebert Web Developmentwalterebert.de

slideshare.net/walterebert

Einige Suchlösungen für Wordpress

● MySQL Standard

● Sphinx WordPress Sphinx Search Plugin

● Lucene WP Search

● Apache Solr Solr for WordPress

Characteristic Search Engine Databases

Basic semantic model Document model Relational data model

Logical storage structure Index Relational table

Representational state De-normalized Normalized

Storage architecture Distributed Centralized

Data models & Storage 1)

1) Search-Based Applications - At the Confluence of Search and Database Technologies, Gregory Grefenstette & Laura Wilber, Morgan & Claypool (2011)

MySQL

SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%tel%') OR (wp_posts.post_content LIKE '%tel%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10

SQL

Wordpress Sphinx Search Plugin

WP Search

Solr for Wordpress

WP Search

Solr for Wordpress

Solr for Wordpress

MySQL

Wordpress Sphinx Search Plugin

WP Search

Solr for Wordpress

Wordpress Sphinx Search Plugin

WP Search

Solr for Wordpress

Solr for Wordpress

Solr for Wordpress

Links

http://de.wordpress.org/http://www.mysql.de/http://codefury.net/projects/wpSearch/http://framework.zend.com/manual/en/learning.lucene.htmlhttp://www.ivinco.com/software/wordpress-sphinx-search-plugin/http://sphinxsearch.com/http://wordpress.org/extend/plugins/solr-for-wordpress/http://lucene.apache.org/solr/features.htmlhttp://www.morganclaypool.com/doi/abs/10.2200/S00320ED1V01Y201012ICR017http://www.digbib.org/