Top 10: HEM performance increase tips

[Patvs]

Could you expand on the monitoring part... I'm using ZoneAlarm and Avast... how do I check if it is and then how do stop it from doing that... thanks.

ZoneAlarm is basically monitoring all your ports... and Avast is constantly monitoring your harddisk for new files.

Since PostgreSQL is a server on port 5432, it can greatly affect performance if a firewall keeps monitoring the data stream.

Therefore with any firewall set exceptions to it for port 5432, and postgres.exe. (so it won't monitor them) If you can't set those exceptions... uninstall it completely.

Similarly, make sure the antivirus program is not monitoring C:/HMArchive, C:/Program Files(x86)/PostgreSQL since there will be a lot of (new) data activity in those folders.

[sjokkomoes]

When I purge hand histories, I assume I will lose them. Wouldnt this mean I lose all my data, should i be forced to make a new database?

[fozzy71]

This post by Pat should answer your questions:

There are two types of purges (delete)
options--> settings--> purge hands (will delete handhistory, hand from graph, $Won from sessions, etc. everything, so hand won't be used anymore for stats)
options--> settings--> observed HH configuration--> purge hands--> will delete the handhistory and therefore the ability to replay the hand, but the hand will still be used for the graph, $Won from sessions and for the HUD.


If you're deleting a lot of hands, it's usually best to just create a new empty database.

[sjokkomoes]

I am doing a manual vacuum+analyse for my db like this:
http://faq.holdemmanager.com/questio...lyze+Database+

Its been at it for 20 minutes now. Doesnt really seem to be adding anything in the log anymore, but the "ok"button isnt appearing. Is it normal yo take this long?

[Patvs]

Vacuum+Analyse can easily take an hour for every 5 million hands in the database on a regular harddisk.

[StonedShisha]

Hi guys

I just recently bought a computer and using SSD drives. Now Im trying to find best way to optimize it and protect the SSD drives from unnecesary writes to HD. and HMarchive came to mind. Do I really need it?

I keep backups of my database pretty often anyway, and that is a quick process. So why exactly do I need hmarchive ?
I would like to remove it to save SSd from unnecessary harddisk writing since that will damage drive performance in the long run

Oh and yes, I have gone through every single step of the top10 performance guide, thx for setting that up btw!

cheers

[netsrak]

HMarchive contains the original handhistories from the pokersite. You may need them in future for importing to a new program or whatever. You should not delete them but you can write them to a different harddisk, external disk or whatever.

[StonedShisha]

But if they are stored in the database, and I backup the database once each month. then it wouldnt matther to keep the handhistory files in hmarchive as they can be exported from my databases at any time, right ?

[Patvs]

Theoretically yes.

Though a database can corrupt for many reasons.
When this happens you will not be able to export the handhistories.
You won't be able to connect to it at all.

With your backups, you run the risk of backupping a database that already is corrupted.

So always save the original handhistories too.
And often export your NOTES, BONUS/RAKEBACK settings.

[StonedShisha]

I see what you str sayying, Im judt trying to avoid too much unnecessary disk-writing to my SSD . I think my idea about backup once each month together with a export hands of that month to a external HDD would work perfect. every now and then you make a backup of notes as well, and there you go. no need for HMarchive!

thx for the help

edit:
unfortuanally for anyone who wanna try this. Keep in mind that exporting tournament hands and results manually is not working correctly. You can export tournament hands but no results in tournaments follows.