Re: [sqlite] One big database or various smaller ones?

2007-03-26 Thread Alberto Simões
On 3/26/07, Joe Wilson <[EMAIL PROTECTED]> wrote: --- Alberto Simões <[EMAIL PROTECTED]> wrote: > The tables are related but they are already being created in parallel > (three tables). I was joining them just because it was easier to move. > But given the new, erm, big size, I think I'll

Re: [sqlite] One big database or various smaller ones?

2007-03-26 Thread Joe Wilson
--- Alberto Simões <[EMAIL PROTECTED]> wrote: > The tables are related but they are already being created in parallel > (three tables). I was joining them just because it was easier to move. > But given the new, erm, big size, I think I'll maintain them split. > > Joe Wilson idea of attaching the

Re: [sqlite] One big database or various smaller ones?

2007-03-26 Thread Alberto Simões
On 3/26/07, Eduardo Morras <[EMAIL PROTECTED]> wrote: At 17:22 26/03/2007, you wrote: >Hi > >I have a database with three tables (bigrams, trigrams and >tetragrams). Basically, they are: > TABLE( A, B, Count) IDX(A,B) IDX(B) > TABLE( A, B, C, Count) IDX(A,B,C) IDX(B) IDX(C) > TABLE( A,

Re: [sqlite] One big database or various smaller ones?

2007-03-26 Thread Eduardo Morras
At 17:22 26/03/2007, you wrote: >Hi > >I have a database with three tables (bigrams, trigrams and >tetragrams). Basically, they are: > TABLE( A, B, Count) IDX(A,B) IDX(B) > TABLE( A, B, C, Count) IDX(A,B,C) IDX(B) IDX(C) > TABLE( A, B, C, D, Count) IDX (A,B,C,D) IDX(B) IDX(C) IDX(D) >

Re: [sqlite] One big database or various smaller ones?

2007-03-26 Thread Joe Wilson
--- Alberto Simões <[EMAIL PROTECTED]> wrote: > I have a database with three tables (bigrams, trigrams and > tetragrams). Basically, they are: >TABLE( A, B, Count) IDX(A,B) IDX(B) >TABLE( A, B, C, Count) IDX(A,B,C) IDX(B) IDX(C) >TABLE( A, B, C, D, Count) IDX (A,B,C,D) IDX(B)

[sqlite] One big database or various smaller ones?

2007-03-26 Thread Alberto Simões
Hi I have a database with three tables (bigrams, trigrams and tetragrams). Basically, they are: TABLE( A, B, Count) IDX(A,B) IDX(B) TABLE( A, B, C, Count) IDX(A,B,C) IDX(B) IDX(C) TABLE( A, B, C, D, Count) IDX (A,B,C,D) IDX(B) IDX(C) IDX(D) Now, this database is quickly getting