YUKI Hiroshi
null+****@clear*****
Thu Feb 5 17:13:17 JST 2015
YUKI Hiroshi 2015-02-05 17:13:17 +0900 (Thu, 05 Feb 2015) New Revision: 4ed7a1da61028fb9dc27031865eddaf96e7b3da4 https://github.com/droonga/presentation-trbmeetup-droonga/commit/4ed7a1da61028fb9dc27031865eddaf96e7b3da4 Message: Add descriptions about demonstration Modified files: fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md Modified: fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md (+19 -8) =================================================================== --- fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md 2015-02-05 10:16:28 +0900 (d2a39b5) +++ fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md 2015-02-05 17:13:17 +0900 (1d085ce) @@ -30,7 +30,10 @@ theme What's *fulltext search*? -# `LIKE` operator in SQL +# Searching without index + +ex. `Array#grep` +ex. `LIKE` operator in SQL ~~~ SELECT name,location @@ -38,8 +41,7 @@ SELECT name,location WHERE name LIKE '%Tokyo%'; ~~~ - * Easy, simple - * Slow + * easy, simple, but *slow* # Fulltext search with indexing @@ -47,13 +49,22 @@ SELECT name,location * Fast!! -# 10,000 records from Wikipedia(ja) +# Demonstration + +Methods +: * `Array#grep` (not indexed) + * `GrnMini::Array#select` (indexed) + +Data +: * Wikipedia(ja) pages + +# Demonstration: Result + +![](images/demo-latency.png){:relative_height="90"} - * Simple `LIKE`: 1.3sec. per query - * Fulltext search: 0.02-0.07sec. per query - * *x20 faster!!* +# How introduce fulltext search? -# How introduce into your Ruby product? +Major ways Sunspot : http://sunspot.github.io/ -------------- next part -------------- HTML����������������������������... Download