How do I seperate observed hands from played hands?

[Degarin]

Looking to datamine some, I want to have a seperate database for the observed hands, as I want to be able to delete this database and re-create it (a new one, starting over) like every 2-3 months or so to keep it fresh).

How do I do this? I don´t want my "old" played hands to be deleted when want to delete all the "old" observed hands.. thats why I´d like to keep them separate obviously.

Thank you for your service!

[fozzy71]

HM's HUD can't read from multiple DBs. You can import the mined hands to your DB and then manually purge the hands, which will leave the HUD stats.


Logging:

I would suggest you turn off logging on your SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips


To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.

------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr'        # Valid values are combinations of
                    # stderr, csvlog, syslog and eventlog,
                    # depending on platform.  csvlog
                    # requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = off        # Enable capturing of stderr and csvlog

File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.


- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.


You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin.
http://www.holdemmanager.net/faq/afm...aspx?faqid=107
http://www.holdemmanager.net/faq/afm...aspx?faqid=163