El 15/10/16 a les 19:49, Jens Alfke ha escrit:

On Oct 15, 2016, at 7:42 AM, Luca Olivetti <l...@wetron.es> wrote:

Instead of an autoincrement you could increment it manually in, say, 1000 
Then, when you have to insert something between 1000 and 2000 you just use 1500.

Unfortunately this breaks down after log2(1000) ≈ 10 insertions, when you may 
have to insert in between two consecutive IDs like 1324 and 1325.

I'm aware of the limitation but for my application[*] it is perfectly fine, maybe it is also ok for the OP, maybe it isn't.

[*] I have to insert records in the given order but the user may occasionally rearrange them.

Luca Olivetti
Wetron Automation Technology http://www.wetron.es/
Tel. +34 93 5883004 (Ext.3010)  Fax +34 93 5883007
sqlite-users mailing list

Reply via email to