Vacuum analyse

**almac** · 04-07-2011, 05:31 AM

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

**Sarek** · 04-07-2011, 06:52 AM

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

**almac** · 04-07-2011, 07:42 AM

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** · 04-07-2011, 08:22 AM

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** · 04-07-2011, 08:33 AM

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** · 04-07-2011, 11:14 AM

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

**almac** · 04-07-2011, 11:45 AM

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 .