Chris
07-29-2006, 05:54 AM
One of the projects on my plate is expanding the search feature at my literature site, so I added a fulltext index to the content table (the table that actually holds the text of all those 1500 books).
mysql> ALTER TABLE Content ADD FULLTEXT(Chp_Text);
Query OK, 35210 rows affected (15 hours 58 min 15.84 sec)
Records: 35210 Duplicates: 0 Warnings: 0
One long *** query.
mysql> ALTER TABLE Content ADD FULLTEXT(Chp_Text);
Query OK, 35210 rows affected (15 hours 58 min 15.84 sec)
Records: 35210 Duplicates: 0 Warnings: 0
One long *** query.