- Kyoto, Japan
- https://pvv.ntnu.no/~oysteikt/
-
ワンワン :3 :3 :3
- Joined on
2023-06-04
Block a user
Get rid of
JMdict_SenseGlossary_byPhrase index for production use
Don't store
JMdict_Sense.language when building with translations from a single language
Externalize
JMdict_Sense.type into a separate table
Retrieve
JMdict_SenseGlossaryType information
Support wildcards in word search
Note that there are glossary phrases for * and _, see https://jisho.org/word/%E2%97%8B
Externalize
JMdict_Sense.type into a separate table
Don't store
JMdict_Sense.language when building with translations from a single language
Use
elementId for XREF__JMdict_KanjiElement__KANJIDIC_Character
This wasn't even used, commenting out the entire table for now
Use
elementId for XREF__JMdict_KanjiElement__KANJIDIC_Character
Don't store kanji + reading in xref tables
Omit rows with basescore 0 in
JMdict_EntryScore
Omit rows with basescore 0 in
JMdict_EntryScore
Waow, we went from 162MB -> 137MB in db size and search benchmarks went from about 1400ms -> 920 ms