On 8 Jan 2015, at 1:43am, Max Vasilyev <maxrea...@mail.ru> wrote: > I guessed that insertion and deletion could be an issue. We need to > re-number keys (change a lot of Btree nodes) on each operation. Or at least > on REINDEX command (I say not strictly, just as idea).
If you need to manually set the numbers of your keys, then your key numbers are just variables and nothing to do with the internal organisation (e.g. Btree) of your database. So create an integer column for them and then you can do what you want with them: index them, UPDATE them, etc.. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users