I did two things:
1. Catted the file to /dev/null
2. Reduced cache_size from 1 down to 2000
I don't know what actions enabled the creation of the index. Before I did
these two things, the index would not create.
Joe Wilson wrote:
>
> --- Joe Wilson <[EMAIL PROTECTED]> wrote:
>> > impro
I am new to sqlite. I have done some reading up. I have a table that I am
having difficulty creating an index on. The table holds ~180 million rows,
simple four column, integer schema. It is taking up about 1.5 gigs of
space. I inherited this application and it is slowing down. The table has
2 matches
Mail list logo