[Groonga-commit] droonga/presentation-trbmeetup-droonga at 4ed7a1d [master] Add descriptions about demonstration

Back to archive index

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 



More information about the Groonga-commit mailing list
Back to archive index