On Mon, 26 Jun 2006 11:20:59 +0100, Brandon, Nicholas (UK) 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.