#1
|
|||
|
|||
How do I speed up PT importing?
Is the only way to upgrade my processor speed?
Would switching to a RAID (faster) HDD speed this up considerably? |
#2
|
|||
|
|||
Re: How do I speed up PT importing?
[ QUOTE ]
Is the only way to upgrade my processor speed? [/ QUOTE ] Yes [ QUOTE ] Would switching to a RAID (faster) HDD speed this up considerably? [/ QUOTE ] No |
#3
|
|||
|
|||
Re: How do I speed up PT importing?
Turn off auto-rating for yourself. This is the single biggest speed-up and is reasily done.
Convert your PT database to PostgreSQL. Instructions are in the Pokertracker forum. Cluster your PostgreSQL database. Instructions are again in the Pokertracker forum. |
#4
|
|||
|
|||
Re: How do I speed up PT importing?
matt42s,
I disagree a little bit. Last year I ripped out my old IDE drives and replaced them with a SATA card & three SATA disks configured as a striped set. I saw a considerable improvement in speed. Since I do a daily backup, I did not bother with RAID 5. A faster processor is certainly anopther way to improve system speed, but a faster hard drive array can also improve things. CB |
#5
|
|||
|
|||
Re: How do I speed up PT importing?
PT3 and HM are being released soon.
On PT I average 10 hands/sec and on HM I'm doing 50 h/s. |
#6
|
|||
|
|||
Re: How do I speed up PT importing?
[ QUOTE ]
Turn off auto-rating for yourself. This is the single biggest speed-up and is reasily done. Convert your PT database to PostgreSQL. Instructions are in the Pokertracker forum. Cluster your PostgreSQL database. Instructions are again in the Pokertracker forum. [/ QUOTE ] is there much of a performance boost gained by changing to postgre? is it faster? smaller db? |
#7
|
|||
|
|||
Re: How do I speed up PT importing?
Hmm, can anyone else confirm the SATA HDD's improve speeds of importing?
|
#8
|
|||
|
|||
Re: How do I speed up PT importing?
Bill, striped SATA drives will result in a considerably faster system overall but would make little difference to PT's import. The PT import is processor bound unless something is badly configured or wrong with the system - ie. the CPU sits in the high 90% range while the drives do very little.
Edit - CPU should sit below 50% in a dual core or 25% in a quad, as the PT import is single threaded - but I don't know this for sure, I'm still running an AMD64 single core. |
#9
|
|||
|
|||
Re: How do I speed up PT importing?
[ QUOTE ]
PT3 and HM are being released soon. On PT I average 10 hands/sec and on HM I'm doing 50 h/s. [/ QUOTE ] That's still slow, PokerAcademy Prospector (using sqlite BTW) has recently set the benchmark at 300 odd hands/sec. Josh and Roy have some catching up to do. |
#10
|
|||
|
|||
Re: How do I speed up PT importing?
[ QUOTE ]
[ QUOTE ] PT3 and HM are being released soon. On PT I average 10 hands/sec and on HM I'm doing 50 h/s. [/ QUOTE ] That's still slow, PokerAcademy Prospector (using sqlite BTW) has recently set the benchmark at 300 odd hands/sec. Josh and Roy have some catching up to do. [/ QUOTE ] On my dev machine, PT3 gets nearly double the hands/sec as HM. [img]/images/graemlins/smile.gif[/img] I can't claim that will be the result for everyone, but there it is. SQLite is not suitable for the type of applications we are building. Too restrictive and not powerful enough. |
|
|