Two Plus Two Publishing LLC
Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

Commercial Software Discussion of commercial gambling-related / poker software & commercial graphics modifications

Reply
 
Thread Tools Display Modes
Old Yesterday, 08:49 PM   #50476
urubu222
journeyman
 
Join Date: Jan 2015
Posts: 251
Re: Holdem Manager Support

Does lots of hands in HM2 database occupy lots of space in computer memory ?

I got 1,6 million hands in my HM2 database and I suspect this is the reason my computer is slow.

How can I delete part of this hands ? Is there a way to delete all hands from 2017 or 2018 ?
urubu222 is offline   Reply With Quote
Old Yesterday, 10:10 PM   #50477
Holdem Manager
Holdem Manager Representative
 
Holdem Manager's Avatar
 
Join Date: Jul 2011
Posts: 4,245
Re: Holdem Manager Support

Quote:
Originally Posted by urubu222 View Post
Does lots of hands in HM2 database occupy lots of space in computer memory ?

I got 1,6 million hands in my HM2 database and I suspect this is the reason my computer is slow.

How can I delete part of this hands ? Is there a way to delete all hands from 2017 or 2018 ?
You can purge hands in the Database Manager. Or you can just create a new database and import only the hands from 2019 (and delete* the old DB if you don't need it to free up space).

Are you using an SSD? There are some SSD specific tips below along with other general info, and links to more info, in regards to database total size and maintaining plenty of free space so you can perform database maintenance. If you ever run out of free space while playing or bulk importing (or have an unexpected PC shutdown) your database is almost certainly going to be damaged and possibly corrupted beyond repair.


Quote:
You can use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller - http://support.microsoft.com/kb/251186

You can put your postgres data folder and the HM2 database parent folder on a different drive but if you move it from a SSD to a HDD you will suffer a decrease in performance - http://hm2faq.holdemmanager.com/ques...e+or+Partition

In HM1 there are a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise. If you don't want the space in your Roaming folder due to limited C: file space, we do give you the option of storing this data anywhere when creating the database.

General rule is 1 million hands = 10 GB.

In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB
HM3:* 6.0*GB

So with a 10 million hand database you need a SSD of at least 60 GB (Windows) + 100 GB = 160 GB. We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

We recommend you maintain more than 20% free space on your system drive. Please see this FAQ to clear up some more free space - http://hm2faq.holdemmanager.com/ques...+of+Disk+Space

Please see these guide to optimize your SSD:

http://www.tomshardware.com/reviews/...weak,2911.html

http://itexpertvoice.com/home/super-...at-them-right/
*If you want to backup/save that current database (and create a new 2019+ DB) and are able to free up 20%+ free space you can back that up before you delete it

*Hopefully you are also aware that all auto import hands get archived to C:\HM2Archive by default. I configured HM2 to archive mine to my google drive cloud subscription personally. You can archive hands to a cloud service you just can not create HM2/3 databases in a sub-folder of your local cloud hosting folder as the constant up/down syncing while you import will also corrupt a database.

Fozzy71
Customer Support
Holdem Manager is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 09:31 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright © 2008-2017, Two Plus Two Interactive
 
 
Poker Players - Streaming Live Online