Hi all!! In my project, i insert rows, one by one, to a fixed size table (1000000 rows for example). When i reach the end of the table, i enter data to the first row and then the seocond and so on. If i have indexes (primary keys), lets say from 1 to 1000000, and now i reached the end, and update the first row with index 1001, does it have to reindex? How much time will it take to reindex? because i will update the second row later with index 1002 and i have to reindex it too, if its true, and i am worry about the performance of such a thing.
-- View this message in context: http://old.nabble.com/Reindexing-%28if-such-a-thing-exist%29-performance-tp32324832p32324832.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