From f6111b26d64ae12774b72cc7604826848b2be3b4 Mon Sep 17 00:00:00 2001 From: David Schlachter Date: Wed, 7 Jan 2026 23:06:03 -0500 Subject: Add index --- setup.go | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'setup.go') diff --git a/setup.go b/setup.go index 49aedd4..6366921 100644 --- a/setup.go +++ b/setup.go @@ -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 -- cgit v1.2.3