RSmith wrote: > On 2014/09/24 22:24, Clemens Ladisch wrote: >> RSmith wrote: >>> I'm liking the link list but did not go with it due to an expensive insert >>> function >> >> Yes, you have to update two references (with prev/next), but how is that >> worse than the update of all SortOrder values? > > Well the insert runs 2-3 times a second
On my machine, inserting a new row and updating the two other rows is just as fast as a single insert, to the limit of the measurement precision. This is because the runtime is dominated by the transaction synchronization. Don't try to optimize something that you have not measured. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users