hello & thanks 4 reply ok, i think i understand, i would like that you, if not prob., write the whole solution once with index on words
Igor Tandetnik wrote: > > "vl.pavlov" <[EMAIL PROTECTED]> wrote > in message news:[EMAIL PROTECTED] >> there is expression: >> >> select count(number) from words where word = bla >> >> which, if i am right, searches through whole table > > Not if you have an index on "word". And you need a unique index anyway > for "insert or replace" part to work (replace only kicks in if insert > would have violated a uniqueness constraint). > > Oh, and the subselect should use "select number ...", not "select > count(number) ...". > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Easy-question-concerning-C%2B%2B---sqlite3-tp15561319p15606736.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
