diff options
| author | Ben Linskey | 2014-02-02 01:47:08 -0500 |
|---|---|---|
| committer | Ben Linskey | 2014-02-02 01:47:08 -0500 |
| commit | 5f0e8a99661f7b4a9b7993bf3cf6f2fa3b78967e (patch) | |
| tree | c1d00f85957c90b4d002bc31634f6ab48e946429 /src | |
| parent | 0c56b5162aa0ae4d153b733ee473432d547e027d (diff) | |
| download | greek-reference-database-creator-5f0e8a99661f7b4a9b7993bf3cf6f2fa3b78967e.tar.gz | |
Update lexicon index
This commit adds the greekLowercase column to the lexicon index. This will
hopefully speed up search queries a bit.
Diffstat (limited to 'src')
| -rw-r--r-- | src/com/benlinskey/grdbc/LexiconCreator.java | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/com/benlinskey/grdbc/LexiconCreator.java b/src/com/benlinskey/grdbc/LexiconCreator.java index 3a242ff..f33007b 100644 --- a/src/com/benlinskey/grdbc/LexiconCreator.java +++ b/src/com/benlinskey/grdbc/LexiconCreator.java @@ -203,7 +203,8 @@ public class LexiconCreator { // Create an index on the three columns matched against search queries. String sql = "CREATE INDEX searchIndex ON " + TABLE_NAME - + " (betaNoSymbols, betaSymbols, greekNoSymbols)"; + + " (betaNoSymbols, betaSymbols, greekNoSymbols, " + + "greekLowercase)"; try { Statement statement = connection.createStatement(); statement.executeUpdate(sql); |