Vacuum analyse

[almac]

Can you still use HEM while doing a vacuum analyse on your database .

[Sarek]

I'd not recommend.
Do you sleep sometimes? Or eat? PC can work at this time, it is metallic.

[almac]

hi sarek , thanks for the reply . the main reason i ask is last time i did it , it took 38 hours but unfotunately i can't sleep that long m8 , i have some important tourneys on tonight in about 6 hours time so that was my main reason for asking . if its not feasible i will just cancel it and do it at a later date .
could you advise on that please

cheers

al

[netsrak]

If you run the vacuum regularly it will not need so much time.

If you stop the running process you may damage your database. I have done this before without damaging my database but just be warned.

You know how to kill a process?

[almac]

Basically that is why i'm going to do it every 3 months . is there a specific way to stop it or just press the cancel button . Maybe do it through task manager and end process .?

[Sarek]

Pressing Cancel don't stop it immediatelly, but Task manager do.
Again: you risk to damage DB.

[almac]

Ok . Many thanks for your responses . I can manage without hem no problem but the vacuuming is really slowing my comp down so may not have an option . I'll fire some tables up now and try it out before my games start . cheers .