On 6/22/10, Eric Smith <eas....@gmail.com> wrote: > I have confirmed that INSERT times are roughly logarithmic in > the number of existing records after creating my specific user > indices. > > But INSERT times appeared to be *linear* in the number of existing > records before I had created any user indices (and with no primary > keys or unique indices defined). > > Can anyone explain this? > > Eric
Insert times should be constant for the 2nd case: no primary key, no indexes; ie, it doesn't matter how many records are already in the database. I confirmed this with SQLite 3.6.18. Did you see my earlier note about combining your two integers into the primary key? This will also give you constant insert times, if you insert items in the order: a=0, b=0 a=0, b=1 a=1, b=0 a=1, b=1 etc. Jim -- HashBackup: easy onsite and offsite Unix backup http://sites.google.com/site/hashbackup _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
