search

hinneburg / TopicExplorer

TopicExplorer
GNU Affero General Public License v3.0
11 stars 3 forks source link

plugin-time-preprocessing: index needed for updates #232

Open hinneburg opened 9 years ago

hinneburg commented 9 years ago

The function updateBestWords in class cc.topicexplorer.plugin.time.preprocessing.tables.wordspertopicperweek.WordsPerTopicPerWeekFill requires that an index is created before doing the updates:

create index topic_week_bestwords_idx on TIME$WORDS_PER_TOPIC_PER_WEEK(WEEK,TOPIC_ID);

This speeds up the updates from hours to seconds!