|
|
我同意
[关闭] [编辑] [删除] [管理]
我察看了英文原版：
For large datasets, it will be much faster to load your data into a table that has no FULLTEXT index, then create the index with ALTER TABLE (or CREATE INDEX). Loading data into a table that already has a FULLTEXT index could be significantly slower.
注意：中文版将 datasets 译为数据库是不准确的，应该为数据集，也就是火箭的意思，一次性插入大量的数据。
下面举的例子，一次性插入多个纪录也验证了这个说法：
mysql> INSERT INTO articles VALUES
-> (NULL,\'MySQL Tutorial\', \'DBMS stands for DataBase ...\'),
-> (NULL,\'How To Use MySQL Efficiently\', \'After you went through a ...\'),
-> (NULL,\'Optimising MySQL\',\'In this tutorial we will show ...\'),
-> (NULL,\'1001 MySQL Tricks\',\'1. Never run mysqld as root. 2. ...\'),
-> (NULL,\'MySQL vs. YourSQL\', \'In the following database comparison ...\'),
-> (NULL,\'MySQL Security\', \'When configured properly, MySQL ...\');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
*********************
酒饮半酣正好
本帖由 侠少 于2003-12-09 15:16:56发表
[关闭] [编辑] [删除] [管理]
[相关文章]
[相关文章]
● 关于MySql的全文搜索 [网址] 【火箭人】2003-12-08 18:47:11 [2982] (437)
○ 不明白的 【晃晃悠悠】2003-12-09 09:01:52 [2440] (614)
■ 是不是指导入大量数据？ 【火箭人】2003-12-09 10:27:48 [2465] (无内容)
■ 我同意 【侠少】2003-12-09 15:16:56 [2233] (1012)
|
|