"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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
