PDA

View Full Version : Ideal import rate?



fizzypants
02-17-2011, 03:13 PM
What's the ideal import rate for HEM?

Mine used to be 100+ hands/sec when I started, now after 200k+ hands, it's around 50 hands/sec. Is this normal? Should I be expecting a further drop as the database gets bigger and bigger?

One more question : Is there any alternative to rebooting the PC if computer/pokerclient becomes slow after importing several hands to the database? Closing HEM doesn't do any good.

fozzy71
02-17-2011, 05:55 PM
What's the ideal import rate for HEM?

There is no ideal rate.


Mine used to be 100+ hands/sec when I started, now after 200k+ hands, it's around 50 hands/sec. Is this normal? Should I be expecting a further drop as the database gets bigger and bigger?


One more question : Is there any alternative to rebooting the PC if computer/pokerclient becomes slow after importing several hands to the database? Closing HEM doesn't do any good.

Import speed slows over time as the database grows. If the PC or client becomes slow often, after importing a few hands, you likely have other issues causing the problems.

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 Options > Hands View Column Selection.
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+#manual
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Smart Defrag.
- Do a Cold Boot (Shut Down > Start) before you use HM
Logging:


http://faq.holdemmanager.com/questions/437/Postgres+Optimization

1 - Options > Database Management... > Connect > Optimize

2 - Select the Database from the Optimization window

3 - I recommend you use the [x] Quick option once a week, or every 10k - 30k hands

4 - Optimize > Yes

Wait for it to finish and change the greyed out Exit button back to a selectable option.


Once a month, or every 50 - 100k hands, you should run a [x] Standard or [x] Full option, instead of the Quick Optimization.


Next we need to Stop the PostgreSQL service so the Defragmenter can Defrag the Database.

Start > Programs > PostgreSQL 8,4 > Stop Server

Open Smart Defrag - Smart Defrag | Best Disk Defrag Freeware | Free Defragmenter (http://www.iobit.com/iobitsmartdefrag.html)

Select both drive letter checkboxes > Analyze

Pick suggested Defrag process > Start Defrag


After Smart Defrag finishes you should restart your computer.

If you need to use HM before you restart your PC, then you need to Start Server.

Start > Programs > PostgreSQL 8,4 > Start Server


*If your Database is on a SSD (Solid-State Drive) you do NOT want to do a defragment.

**If you have a SSD and install the Smart Defrag software you want to open the Auto Defrag tab and disable the [ ] Enable Auto Defrag. On the Schedule tab you should turn off the [ ] Enable Schedule. On the Options tab you should enable the [x] Do not display flash drivers and solid-state drivers. That will make sure your SSD is never defragmented, on purpose, or by accident.

fizzypants
02-19-2011, 03:22 PM
Thanks a lot!



- Turning off logging and deleting existing logs


How do I do that? The postgres.conf file in notepad shows log_collector is off by default only and there was only 1 log file in my postgres folder.

netsrak
02-20-2011, 07:07 AM
Then logging probably is already disabled.

fizzypants
02-20-2011, 07:13 AM
Then logging probably is already disabled.

Cool thanks.