Shaun Seckman (Firaxis) <shaun.seck...@firaxis.com> wrote: > Currently, in my database I'm storing thousands of > strings that are formatted in such a way where they share similar > prefixes (i.e. TXT_KEY_FOO, TXT_KEY_BAR). Sadly, this format cannot > be changed so I was wondering if it would be possible and perhaps > faster to have SQLite perform reverse string comparisons for looking > up specific strings.
You can write a custom collation that compares the strings the way you want, then build an index and perform searches based on that collation. See http://sqlite.org/c3ref/create_collation.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
