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?

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

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.

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

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.

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?

Re: How do I speed up PT importing?
 

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

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.

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.

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.