french-wiktionary-flashcards

commit f6111b26d64ae12774b72cc7604826848b2be3b4
parent cafc25dc82d5ecb5fa0da4ea80f14bf2ad550f3c
Author: David Schlachter <t480-debian-git@schlachter.ca>
Date:   Wed,  7 Jan 2026 23:06:03 -0500

Add index

Diffstat:
M
setup.go
 | 
7
++++++-

1 file changed, 6 insertions(+), 1 deletion(-)
diff --git 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