Ok, I'm working on a simple project, which will reproduce a problem. Valentine.
11.06.2013, в 17:30, Dan Kennedy <danielk1...@gmail.com> написал(а): > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
