diff options
| -rw-r--r-- | setup.go | 7 |
1 files changed, 6 insertions, 1 deletions
@@ -87,7 +87,7 @@ func readDictionary(db *sql.DB) error { var wordsAdded int scanner := bufio.NewScanner(file) - maxCapacity := 1_000_000 + maxCapacity := 2_000_000 buf := make([]byte, maxCapacity) scanner.Buffer(buf, maxCapacity) @@ -151,6 +151,11 @@ func readDictionary(db *sql.DB) error { return fmt.Errorf("committing: %w", err) } + _, err = db.Exec("create index wordindex on words(word);") + if err != nil { + return fmt.Errorf("creating index: %s", err) + } + log.Printf("prepared %d dictionary entries", wordsAdded) return nil |
