| Index: trunk/WikiWord/WikiWordBuilder/src/main/java/de/brightbyte/wikiword/store/builder/DatabaseWikiWordConceptStoreBuilder.java |
| — | — | @@ -373,8 +373,8 @@ |
| 374 | 374 | protected int buildLangMatch() throws PersistenceException { |
| 375 | 375 | final String sql = "INSERT IGNORE INTO "+relationTable.getSQLName()+" (concept1, concept2, langmatch)" + |
| 376 | 376 | " SELECT LL.concept, LR.concept, 1 " + |
| 377 | | - " FROM "+langlinkTable.getSQLName()+" as LL " + |
| 378 | | - " JOIN "+langlinkTable.getSQLName()+" as LR ON LR.language = LL.language AND LR.target = LL.target "; |
| | 377 | + " FROM "+langlinkTable.getSQLName()+" as LL force index(concept_language_target) " + |
| | 378 | + " JOIN "+langlinkTable.getSQLName()+" as LR force index(language_target) ON LR.language = LL.language AND LR.target = LL.target "; |
| 379 | 379 | |
| 380 | 380 | final String where = " LL.concept != LR.concept "; |
| 381 | 381 | final String rest = " ON DUPLICATE KEY UPDATE langmatch = langmatch + VALUES(langmatch) "; |