PDA

View Full Version : delete part of the database?



RainbowJJ
12-25-2010, 05:59 AM
I were playing on Pokerstars and Ipoker, but only on Ipoker now. I have about 600K hands from Pokerstars (about 550K is purcharged). My database is very slow when I try to refresh.

How can I delete my cashgames hands from Pokerstars and all my tournament hands?

I still want to be able to review the cash games hands from Ipoker. Is it possible to only delete part of the database?

BR. RainbowJJ

Sarek
12-25-2010, 06:41 AM
see this FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands (http://faq.holdemmanager.com/questions/197/Purge+Hands)

RainbowJJ
12-25-2010, 01:18 PM
I tried that with succes and HEM is running much faster now.
Is the hand deleted now?

Sarek
12-26-2010, 06:32 AM
sincerelly said, DB needs manual vacuum
FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)
but make a backup first (via Pgadmin too)