Changes between Version 1 and Version 2 of FulltextSearchIdeas

Timestamp:

06/17/05 16:39:44 (20 years ago)

Author:

lauer

Comment:

--

FulltextSearchIdeas

@@ -1 @@
-for mysql, we need MYISAM
+for mysql, we need MyISAM tables 
+
+e.g.
+mysql> CREATE TABLE articles (
+    ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
+    ->   title VARCHAR(200),
+    ->   body TEXT,
+    ->   FULLTEXT (title,body)
+    -> );
+
+example query:
+mysql> SELECT * FROM articles
+    -> WHERE MATCH (title,body) AGAINST ('database');
+
+
+Hints from MySQL documentation: 
+
+Loading data into a table that has an existing FULLTEXT index 
+could be significantly slower. 
+
+For large datasets, it is much faster to load your data into 
+a table that has no FULLTEXT index, then create the index 
+with ALTER TABLE (or CREATE INDEX)