Hello all I'm new with sqlite3 and sql.
I have data base that include path columns (file system path like c:\bla bla\myFiles\1.txt) On that columns I need to do 1) search for patterns in case the user want to find a file or directory 2) search for prefix path in case the user rename a file or directory the Database include about 1.5-2.5 million records and to use the "LIKE" is not possible because the result time. As an alternative I want to use FTS3 or FTS4 but I think I have a problems with what I read here: http://www.sqlite.org/fts3.html#section_1_4 And here: http://www.sqlite.org/fts3.html#section_6_3 I need to specify the language to FTS to use it as tokenize but the path can include multi languages how can I configure the FTS table to use all languages How can I tell to FTS to token the path only according to the character "\" ? More than that when creating FTS table it creates with the TEMPORARY key word. My question is: do I need to create this table each time I run the data base (because the temporary word) or for each connections (in case of multiconnections) or this is a table like all tables I declared and it stay in the data base even if I restart my PC Thanks a lot _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
