Hi,
this is the exact table definition:
create table wordlinks (
id integer primary key,
document integer,
docword integer,
count integer
)
in fact i wouldn't need the primary key. i need an index on docword and
rene wrote:
My questions are:
*is this a bug?
*why does indexing take that long?
*will it be fixed in 3.0?
*should i consider using embedded mysql instead (not tested that if it got better performance
though)?
*would it help if i create a seperate database for this particulair table? (there is ab
Hi,
well, i put most things in transactions, but in this case that wouldn't make a
difference.
the query was simply:
create index idx_linktable on linktable (wid)
that ran for hours and hours on the huge table until i killed it, or with benchmarks
as described
in previous post on the tables w
...
> now, i tried to put the index on the table afterwards. i tried this when
> the table was real big
> (600Mb, about 40.000.000 rows).. After six hours, sqlite had read and
> wrote 150Gb (!) to disk
> (that is: reading 150Gb, writing 150Gb according to windows taskman) the
> job still wasn't don
Hi,
i have the following problem: in my database is one specific table that gets quite a
lot of
inserts..the table consist only of a primary key and three integer values. I need to
index, besides
the primary table, 2 more columns on the table. there is no option to put a 'unique'
index.
if i p
5 matches
Mail list logo
