View Full Version : 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 .
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.