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
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
>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?
Nick
Aha, sorry Richard, it seems you may have been right. I downloaded a
different gui call SQLite Administrator and it is importing now. The first
gui i used, used 100% of my cpu and crashes, this new one doesn't use much
but it is a sloow process.Have been running it for about 10 mins
Thanks guys,
Richard: The reason i didn't mention the software is because all guis just
create the text commands anyway so they all do the same thing. I doubt it is
a problem with the gui i used which was "SQLite database browser".
Chris: Thanks for that but i dont know how that helps me. Are
There was a small error in my previous post.
The 'begin transaction;' line was missed when
I copied the text out of the script and editted
it to remove the code around the text.
On Sat, 24 Jun 2006 20:10:58 -0700 (PDT), onemind wrote:
>I am using the sqlite gui and click import table from csv. I
On Sat, 24 Jun 2006 20:10:58 -0700 (PDT), onemind wrote:
>I am using the sqlite gui and click import table from csv. I select a txt
>file that contain over 200,000 words in a list. Sqlite works fine with a
>smaller list of 200-300 words but when i import my big list, it hangs for
>ages or
7 matches
Mail list logo