PDA

View Full Version : Maximum # of Hands in Database



mangzona
10-04-2009, 10:04 PM
What is the maximum (or is there one?) number of hand I can import into a database?

fozzy71
10-04-2009, 11:36 PM
It is only limited by your Hard Drive size and machine performance. The postgresql DB will perform best if it is on it's own physical hard drive, so it isn't sharing read/write with your OS. The larger the DB, the slower it will become in terms of bulk import speed and general performance. This can be maximized by regular DB and Hard drive maintenance. You should also turn off the SQL Logging before importing massive numbers of hands. It isn't uncommon for someones DB to be taken up by 75% log files. :(

I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again