On Fri, 13 Feb 2009 16:06:42 +0530, aalap shah <[email protected]> wrote in General Discussion of SQLite Database <[email protected]>:
>Hi, > >I am using sqlite3 for my search application and i want an optimized >way for retrieving values from table. I need a way in which I can >query records from the result of previous query based on next search >character. >so for example >If i search for words starting with "a" then if user enters "b" then i >want to search for words starting with "ab" from the ones that were >retrieved in my last query . You can try to build something smart with TEMPORARY TABLEs and/or indexes on substrings of words, but the first approach would be well chosen page- and cache sizes. When the database is only used for this purpose and there is no concurrent access this will usually be good enough. Will you use FTS? http://www.sqlite.org/cvstrac/wiki?p=FtsTwo >Can any one help me with this. It would be really helpful to me. >Thank You in Advance -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
