PDA

View Full Version : Can a HEM database run on a USB key?



chalminho10
12-17-2009, 09:03 PM
I have a HEM database on a fast desktop. I'd like to use this DB on a laptop but its HDD is pretty slow and does not have much empty space.

Now, I have a fast USB key. Is there any way to copy my HEM DB on this key and run this copy from the USB key only (i.e., no copy of the DB on the laptop HDD; all data would be processed from the key) on my laptop?

If yes, can you please explain how?

Thanks a lot.

fozzy71
12-17-2009, 10:40 PM
I would not recommend this, even though it may be technically possible. The internal SATA connection is faster than USB 2.0 connections. Maybe I should try and do this myself, to see how well it works. :S

Try using WinDirStat (http://windirstat.info/)to find and delete the files that are taking up all the space, so you have more room.

You may want to turn off logging and delete the log files of your DB, if you haven't already done it.


I would suggest you turn off logging on your new 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/afmviewfaq.aspx?faqid=107
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163