View Full Version : Moving the HH (HM Archive Folder) to a diff drive???? How?????
popetman
12-14-2010, 04:42 PM
Hi,
My c drive is running low on memory, as it's small and I have far too many HH's.
So I copied the HM HH file to my larger F Drive
How do I now point HM to the HM Archive folder now sitting in my F Drive, so I can delete the one in my C Drive ??????
I think if I do this then HM will still grab all my HH from FT and put them into this new folder, so all my problems will be solved.
I have looked at all the menus on HM and can't see the option.
Thanks for any help x
popetman
12-14-2010, 05:28 PM
solved by fozzy (as ever) so if any one else has this, this was fozzy's advice/solution - thanks again sir
To verify/edit the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________
http://faq.holdemmanager.com/questio...Import+Folders
The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).
If your postgresql database is on your C drive it is likely much large than your archive folder. I use a program called WinDirStat to visually see what files take the most space on my partitions.
Logging:
I would suggest you turn off logging on your new SQL installation as well as these other performance improvements in my signature - 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.
HTML Code:
------------------------------------------------------------------------------
# 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.
Regarding database maintenance:
You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin. You do not want to purge any Hero hands so make sure your alias is properly configured before purging.
http://faq.holdemmanager.com/questio...+from+Database
FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands (http://faq.holdemmanager.com/questions/197/Purge+Hands)
Then you can vacuum/analyze - http://faq.holdemmanager.com/questio...tabase+#manual
Before you defragment you should stop the PostgreSQL service:
Start > Programs > PostgreSQL 8.x > Stop Server
Use your favorite defrag tool. I recommend Smart Defrag.
After defrag I recommend you reboot your PC. If you need to access the DB before rebooting you can start the PostgreSQL service.
Start > Programs > PostgreSQL 8.x > Start Server
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.