--- 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) IDX(C) IDX(D) > > Now, this database is quickly getting around the 2GB of disk space. > My question, about efficiency, is, it better to have: > - one big database, one connection from C code to the database > - three smaller databases, three connection from C code to the database
It depends on how and how frequently they are populated, but I'd suggest 3 database files, one connection from C code with 2 ATTACH DATABASE commands. http://sqlite.org/lang_attach.html ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
