YUKI Hiroshi
null+****@clear*****
Fri Nov 1 19:03:48 JST 2013
YUKI Hiroshi 2013-11-01 19:03:48 +0900 (Fri, 01 Nov 2013) New Revision: 6be6d53d7cd78d709d5d68413185a19a85363796 https://github.com/droonga/fluent-plugin-droonga/commit/6be6d53d7cd78d709d5d68413185a19a85363796 Message: Don't create index for Subscriber.last_modified. There are two reasons: 1. Records of "Times" table will increase innfinitly. 2. Because expired subscribers are automatically removed by the sweeper, it won't cost to search newly expired subscribers. Modified files: ddl/watchdb.grn ddl/watchdb.jsons Modified: ddl/watchdb.grn (+0 -1) =================================================================== --- ddl/watchdb.grn 2013-11-01 18:09:39 +0900 (bed4da6) +++ ddl/watchdb.grn 2013-11-01 19:03:48 +0900 (41e8f50) @@ -6,7 +6,6 @@ table_create Times TABLE_PAT_KEY Time column_create Subscriber subscriptions COLUMN_VECTOR Query column_create Subscriber route COLUMN_SCALAR Route column_create Subscriber last_modified COLUMN_SCALAR Time -column_create Times Subscriber_last_modified COLUMN_INDEX Subscriber last_modified column_create Query keywords COLUMN_VECTOR Keyword column_create Query subscribers COLUMN_INDEX Subscriber subscriptions column_create Keyword queries COLUMN_INDEX Query keywords Modified: ddl/watchdb.jsons (+0 -1) =================================================================== --- ddl/watchdb.jsons 2013-11-01 18:09:39 +0900 (347e42a) +++ ddl/watchdb.jsons 2013-11-01 19:03:48 +0900 (33061c4) @@ -6,7 +6,6 @@ {"id":"b0f248a3555bc744fcc2e1504b54b6245e79dfe8","date":"2013-10-31T11:48:25+09:00","replyTo":"localhost:20033/output","statusCode":200,"dataset":"Watch","type":"column_create","body":{"table":"Subscriber","name":"subscriptions","flags":"COLUMN_VECTOR","type":"Query"}} {"id":"fd88060579dafdd64ec38baf57881d2893e24146","date":"2013-10-31T11:48:25+09:00","replyTo":"localhost:20033/output","statusCode":200,"dataset":"Watch","type":"column_create","body":{"table":"Subscriber","name":"route","flags":"COLUMN_SCALAR","type":"Route"}} {"id":"40f9d14e881e09dd965cac09b4f6b452993c011b","date":"2013-10-31T11:48:25+09:00","replyTo":"localhost:20033/output","statusCode":200,"dataset":"Watch","type":"column_create","body":{"table":"Subscriber","name":"last_modified","flags":"COLUMN_SCALAR","type":"Time"}} -{"id":"1d95936c9bf232db8cb48c16bdef8b1183075c7a","date":"2013-10-31T11:48:25+09:00","replyTo":"localhost:20033/output","statusCode":200,"dataset":"Watch","type":"column_create","body":{"table":"Times","name":"Subscriber_last_modified","flags":"COLUMN_INDEX","type":"Subscriber","source":"last_modified"}} {"id":"99604cf73c49fbc1b5ceb0de8bae5fa66f5276bc","date":"2013-10-31T11:48:25+09:00","replyTo":"localhost:20033/output","statusCode":200,"dataset":"Watch","type":"column_create","body":{"table":"Query","name":"keywords","flags":"COLUMN_VECTOR","type":"Keyword"}} {"id":"e4ebc547d4b8ec85c1009af4ad4ffd0c2405b755","date":"2013-10-31T11:48:25+09:00","replyTo":"localhost:20033/output","statusCode":200,"dataset":"Watch","type":"column_create","body":{"table":"Query","name":"subscribers","flags":"COLUMN_INDEX","type":"Subscriber","source":"subscriptions"}} {"id":"a1dcea88e1213a1cf67eac78e5b636ceb1ffd241","date":"2013-10-31T11:48:25+09:00","replyTo":"localhost:20033/output","statusCode":200,"dataset":"Watch","type":"column_create","body":{"table":"Keyword","name":"queries","flags":"COLUMN_INDEX","type":"Query","source":"keywords"}} -------------- next part -------------- HTML����������������������������...Download