caddy report shows hands 2x

[poporella]

caddy report shows hands 2x

8e6d97dbd1111f68e177ce3ecbae3c42.png

+how can i save the tabs as follows: cards/ potsize/ check mark ?

I always have to reorganize that each session.

[udbrky]

1) Please close HM

2) Please open PGAdminIII

It is in the Start -> Postgres folder.

3) Enter your postgres password. The default password is typically postgrespass.

4) Open the databases.

5) Highlight your database.

6) Right click, click maintenance.

7) Run the vacuum and analyze and reindex functions.

http://faq.holdemmanager.com/questio...lyze+Database+

Please try again.

[poporella]

i have an SSD drive. Think we should not do the maintenance on SSD drives?

[udbrky]

It is fine to do.

Out of HM1, HM2, PT3, HM2 has by far the smallest DB's.

Some SSD's now use compression automatically. The Truth About SSDs and Compression

You can also use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller:

Best practices for NTFS compression in Windows

You can put your postgres data folder and the HM2 database parent folder on a different drive.

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, many of which are yet to come. If you don't want the space in your Roaming folder due to C: file space or something like that, we do give you the option of storing this data anywhere

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

So with a 10 million hand database you need as 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.

You can also run tree size free to locate wastes of space:

TreeSize Free - Quickly Scan Directory Sizes and Find Space Hogs

Please see this guide to optimize your SSD:

Can You Get More Space Or Speed From Your SSD? - Optimizing Precious Solid-State Storage

Here is another guide:

Super-Fast SSDs: Four Rules for How To Treat Them Right « IT Expert Voice

[poporella]

that maintenance didnt work. Still getting multiple Hand copys.

[Patvs]

Create a new database, and reimport your hands.

Any 'duplicate hands' is the sign of a corrupt database. (which a REINDEX can only sometimes fix)

[Patvs]

+how can i save the tabs as follows: cards/ potsize/ check mark ?

It's not possible to change the order, and then save the new order of the tabs.

[poporella]

hey just 15 days ago i installed the SSD reinstalled windows and all programs and built a new database and reimported all hands.

Cant do this every couple of days?

and still have those lagging/ freezing probs after couple hours of multitabling play, SSD didnt changed that much of performance increase.

[Patvs]

How many hands did you import?
How many notes do you have? Are you using many custom notes and NoteCaddy badges?



After you've imported all your hands, create a BACKUP of the database.
It's 100x faster to restore a back, than having to reimport all your hands if you have a large database.

[poporella]

600k hands imported. (i delete all hands older than haölf a year every end of month)
i dont write notes in HM
I used Notecaddy trial for the last month with only a few preflop definitions and badges.
since Notecaddy trial is over, performance issues still exist (-> lagging/ freezing for a couple of seconds... after long multitabling sessions)