On 06/11/2013 08:20 PM, Valentine Silvansky wrote:
Hi all!
I have a custom-built sqlite with FTS4 and unicode61 tokenizer for it. I've got the only
one table "messages":
CREATE VIRTUAL TABLE messages USING FTS4(body TEXT, tokenize=unicode61);
So, I populate this table with ~100k entries, each one is a sentence (or a
short message) in english or russian. So when I execute SELECT query with
english text in MATCH, I got result less than in a second, but when query is in
russian, it takes minute and more to get result.
I need a case-insensitive search in any language, so I used unicode61 tokenizer.
My code is written for OS X 10.8, SQLite version is 3.7.16, custom defines are
SQLITE_ENABLE_FTS3 and SQLITE_ENABLE_FTS4_UNICODE61.
Is there a way to boost up the search?
Are you able to make the database file and a couple of
example queries available?
Thanks,
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
