On Oct 29, 2008, at 4:59 AM, Julian Bui wrote: > Hi everyone, > > First off, I'm a database and sqlite newbie. I'm inserting many many > records and indexing over one of the double attributes. I am seeing > my insert times slowly degrade as the database grows in size until > it's unacceptable - less than 1 write per millisecond (other databases > have scaled well). I'm using a intel core 2 duo with 2 GB of ram and > an ordinary HDD. > > I am trying to figure out why some of the other databases (firebird, > mysql, berkeley db) have provided constant insert speeds whereas > sqlite has not.
i can tell you firsthand that berkeley db does not provide anything like constant time for random inserts into a btree as it's size grows. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
