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 inserti
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
>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
an
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 y
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 complete
onemind <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am using the sqlite gui
There is no "sqlite gui". SQLite is a C library. There is
also a bundled command-line program that uses that C library.
But no GUI.
There are multiple GUIs for using SQLite that are available
seperately. But no one of
8 matches
Mail list logo
