On 19 Jun 2010, at 1:24am, Eric Smith wrote: > It's not in any way a result of my schema? My primary key is a pair of > integers A,B. The first column in this particular use case is in the > range A = [0, 2million) and the second is in the range B = [0, infinity). > We > > insert records A=0->2million, B=0, then > insert records A=0->2million, B=1,
We know you are doing a huge amount of writing to this database. Are you also reading it frequently ? If not, then it might be worth making an index on that primary key only when you're about to need it. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
