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 ? And what about files in
var/aspseek/NNw/ ? Can I ignore them
Thanks,
Andrej
