On 6/26/06, C.Peachment <[EMAIL PROTECTED]> wrote:
>>The use of sequential numbers as the trailing part of the 'word' >>results in a continual rebalancing of the b-tree with each insertion. >Is that right considering it looks like you have not created an index on >the word column before inserting the data? Oops, you got that right :-) I was doing a lazy Sunday morning quick and dirty implementation and forgot to define the index. If you assume there had been a PRIMARY KEY phrase after the field definition then I think my comment would be valid.
I wrote a command line importer. You're welcome to try it if your problem wasn't already solved. It is much slower to insert into an indexed table than to insert all the records then create the index. It doesn't use time rebalancing the trees when it's done as a batch at the end. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
