Manual Import Speed...

[LondonCardPlayer]

I've recently purchased a new PC and have been Importing my hands into Poker tracker again since Friday.

On Friday, hands were importing at around 250 h/s, and obviously was very impressed with the new PC. On Saturday this speed dropped to a constant 170 h/s, and earlier today its been down to about 60 - 80 h/s and about 20 mins ago I was about to Import sort more hands, and now it's only going at 15 h/s.

I don't really understand what the reason for the massive slowdown is. I've been running full house keeping every 50k hands. My PC is only 3 days old and I've only imported around 250,000 hands. Do you guys have any ideas as to why it's gone from 250 h/s down to under 20 h/s in 3 days or what may have caused it?

Should I just give the importing hands thing a rest for a couple of days?

Basic PC specs if it helps;

Intel i7 2.8 Ghz Quad Core
6 Gb DDR3 (1300 mhz)
1 Tb HDD
Windows 7 HP 64 bit

And running latest version of PT3.

[WhiteRider]

The bigger the database the longer it takes to add each new hand, but I wouldn't expect such a significant slowdown for that many hands.

What version of PostgreSQL do you have? See Database > Database Management.
If it's 8.3.x but not 8.3.9 or 10 then you should update - Directions here.

Other than that, please report your problem so that we can investigate further.

[LondonCardPlayer]

I've got version v8.3.9

Should I still update?

It it a better idea to create different databases for every 200k hands. Can you configure PT3 to read from multiple databases while it's running, or will it only read from One database at a time?

[WhiteRider]

8.3.9 is fine.
You don't need to create separate databases, but if you're importing a lot of observed hands you might find something like this useful - Tutorial: Managing Multiple Databases.

[LondonCardPlayer]

I don't have observed hands. I've just got my hands going back to 2007. This is the first time I've ever used any poker software, but I've been saving hand histories since I started playing. I only have another 75-100k hands to import, so I think I'll just do it a bit at a time.

Thanks for all your help.

[WhiteRider]

Yes, if you import the files in batches (of less than say 5000 files) it shouldn't slow too much.
Just import everything in whatever batches you want and then run housekeeping once at the end - you don't need to do it after every import if you're going to be importing again straight away.

[LondonCardPlayer]

I'll do that.

Thanks for all your help.