logN lookup time should be just fine for the WSTText indexes.
Using the SHA512 hash of the text content deals with the text uniqueness constraint and also is a much more clear differentiation compared to using a text index.
Since 512 bits in hex fits within the max key spec, I added the text length to the key as well, for the infinitesimally small chance we encounter the pigeonhole principle lol
logN lookup time should be just fine for the WSTText indexes.
Using the SHA512 hash of the text content deals with the text uniqueness constraint and also is a much more clear differentiation compared to using a text index.
Since 512 bits in hex fits within the max key spec, I added the text length to the key as well, for the infinitesimally small chance we encounter the pigeonhole principle lol