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

Reply via email to