How do I speed up PT importing?

choose123 · #1 08-19-2007, 08:40 AM

Is the only way to upgrade my processor speed?

Would switching to a RAID (faster) HDD speed this up considerably?

matt42s · #2 08-19-2007, 11:44 AM

[ 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

Triggerle · #3 08-19-2007, 02:20 PM

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.

CudjoeBill · #4 08-19-2007, 02:43 PM

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

ICMoney · #5 08-19-2007, 07:24 PM

PT3 and HM are being released soon.

On PT I average 10 hands/sec and on HM I'm doing 50 h/s.

phantom_lord · #6 08-19-2007, 08:20 PM

[ 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?

michaelantoi · #7 08-19-2007, 09:35 PM

Hmm, can anyone else confirm the SATA HDD's improve speeds of importing?

matt42s · #8 08-20-2007, 06:37 AM

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.

matt42s · #9 08-20-2007, 06:43 AM

[ 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.

PokerAce · #10 08-20-2007, 02:09 PM

[ 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.