----- Original Message -----
From: "Andrej Filipcic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 5:15 PM
Subject: Re: [aseek-users] memory requirements
> On Fri, 23 Feb 2001, Alexander F. Avdonkin wrote:
>
> > > I have ~5M pages (~3.5M with deleted=0) in db. index -D requires about
> > > 500M of memory (400M resident) for loading ranks and saving citations.
> > > Is it possible to reduce that?
> > >
> >
> > Unfortunately, there is no quick way to reduce amount of memory.
> -------------
> Well, if I remove deleted=1 records from db, it would help. What is the
> proper procedure to do that?
>
I think, that removing records with deleted=1 will not help much.
Nethertheless, here is the procedure for removing those records:
First, make sure, that all delta files has zero length, otherwise you
have to save them.
Then you can run SQL statement "DELETE FROM urlword WHERE deleted!=0".
Note, that this statement might run long time, and MySQL is not able to
get data from table "urlword" during "DELETE",
resulting in impossibility of search at that period of time.
> Thanks,
>
> Andrej
>
