On Feb 13, 2008, at 11:12 AM, [EMAIL PROTECTED] wrote:
> Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote:
>> I have a table with two variables, say A and B (both integers). The
>> table is rather large - around 2.9 GB on disk. Every combination of
>> (A,B) occurs only o
I have a table with two variables, say A and B (both integers). The
table is rather large - around 2.9 GB on disk. Every combination of
(A,B) occurs only once. I am creating a unique index as
CREATE UNIQUE INDEX ABidx ON abtable (A,B)
It seems that the (A,B) index is created much slower than
On Jul 19, 2007, at 8:45 AM, Ahmed Sulaiman wrote:
Hi all,
Does SQLite work on Mac, and if yes, is there any Mac enabled version
that I could download?
SQLite is part of MacOS X. Try typing sqlite3 at the command line...
Kasper
Cheers
On May 10, 2007, at 11:08 PM, Juri Wichanow wrote:
For "create index.." in large database : "pragma
default_cache_size = 2000;"
For "select ..." -- "pragma default_cache_size = 1200;"
Hmm, quite interesting.
I would like to share my naive observations, which led me to believe
the c
On May 10, 2007, at 3:04 PM, [EMAIL PROTECTED] wrote:
Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote:
Hi
We are using SQLite for a fairly big (but simple) calculation, and
have some problems when creating an index on a database with
600.000.000 rows. Specifically it has not ended even
Hi
We are using SQLite for a fairly big (but simple) calculation, and
have some problems when creating an index on a database with
600.000.000 rows. Specifically it has not ended even after 5 days of
running. We have done it successfully on 25% of the full data base,
and are now wondering
6 matches
Mail list logo