HAYASHI Kentaro
null+****@clear*****
Wed Sep 18 15:50:39 JST 2013
HAYASHI Kentaro 2013-09-18 15:50:39 +0900 (Wed, 18 Sep 2013) New Revision: 005cfcb4ea04617d71c73dca1b67a6cf277fe353 https://github.com/groonga/groonga/commit/005cfcb4ea04617d71c73dca1b67a6cf277fe353 Message: doc: add note about indexes Modified files: doc/source/tutorial/match_columns.txt Modified: doc/source/tutorial/match_columns.txt (+9 -0) =================================================================== --- doc/source/tutorial/match_columns.txt 2013-09-18 11:56:38 +0900 (8aa5779) +++ doc/source/tutorial/match_columns.txt 2013-09-18 15:50:39 +0900 (171b147) @@ -76,6 +76,15 @@ match_columnsオプションで、検索対象のカラムを複数指定する .. select --table Blog2 --match_columns title||message --query message .. select --table Blog2 --match_columns title --query message +.. note:: + + There may be a question that "which is the better solution for indexing." + It depends on the case. + + * Indexes for each column - The update performance tends to be better than multiple colum index because there is enough buffer for updating. On the other hand, the efficiency of disk usage is not so good. + * Indexes for multiple column - It saves disk usage because it shares common buffer. On the other hand, the update performance is not so good. + + インデックス名を指定した全文検索 -------------------------------- -------------- next part -------------- HTML����������������������������... 下载