----- Original Message -----
From: "Andrej Filipcic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 5:42 PM
Subject: Re: [aseek-users] memory requirements
> On Fri, 23 Feb 2001, Alexander F. Avdonkin wrote:
>
> > > 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.
> ----------------
>
> Can I delete also from urlwordsNN ?
Yes.
And what about files in
> var/aspseek/NNw/ ? Can I ignore them
It is these files are used by search. They are not related to PageRanks
calculation. Don't delete them.
>
> Thanks,
>
> Andrej
>
