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
For "create index.." in large database : "pragma default_cache_size = 2000;"
For "select ..." -- "pragma default_cache_size = 1200;"
Juri
Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote:
>
> Having said that, I can understand that sorting and disk cache and so
> on factors in - but my initial database is already very large (1.3GB
> - 145.000.000 milion rows), and surely that disk cache would already
> factor in at that stage?
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 after
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 after 5 days of
> running. We have done it
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
6 matches
Mail list logo