Slllooowww importing & housekeeping

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Slllooowww importing & housekeeping

Postby markotm » Sat Jan 14, 2012 12:16 pm

I imported 441610 ongame hands in 531 separate files manually, that took 1:16:22 (96.4 h/s) and after that the housekeeping has been going on for almost 5 and a half hours and it looks like it is about half way rebouilding cache. This can´t be normal speed..?? My cpu is i7-2630QM, 8GB RAM and windows 7 64-bit. PostgreSQL is 9.0.
markotm
 
Posts: 77
Joined: Sun Dec 06, 2009 1:53 pm

Re: Slllooowww importing & housekeeping

Postby WhiteRider » Sat Jan 14, 2012 4:36 pm

That does seem a bit slow for housekeeping, but it does depend on the content of the data. Do you have a lot of custom stats?
The update may not take as long as the progress bar suggests. If you have logging enabled please attach your PokerTracker.log file to a Support Ticket so that we can see what was taking the time.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Slllooowww importing & housekeeping

Postby markotm » Sun Jan 15, 2012 2:48 am

Sorry but I don´t have the logging enabled... now the housekeeping has been going on for 20 hours. I do not have any custom stats if You mean something that I would have done myself, I have not changed anything in PT3. I got some help from Mike (Peligroso) in a similar issue before (ticket 112380) and after that everything has worked ok until now. I don´t remember tho if this might be the first time I import Ongame hands, I think I have imported only Tilt and Stars hands before.
markotm
 
Posts: 77
Joined: Sun Dec 06, 2009 1:53 pm

Re: Slllooowww importing & housekeeping

Postby WhiteRider » Sun Jan 15, 2012 7:00 am

OnGame hands shouldn't make much difference to the cache rebuild speed.
Is the cache update still progressing? If it is, and it's near the end I'd suggest leaving it, otherwise you may want to end the process and restart PT3 via the 'Logging Enabled' option in the Start menu, and start Database > Housekeeping again. It really shouldn't take that long but if it is slow again we'll be able to check the end of the PokerTracker.log to see how it is progressing, and see if anything looks wrong.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Slllooowww importing & housekeeping

Postby markotm » Sun Jan 15, 2012 7:18 am

Housekeeping ended after about 21 hours...
markotm
 
Posts: 77
Joined: Sun Dec 06, 2009 1:53 pm

Re: Slllooowww importing & housekeeping

Postby WhiteRider » Sun Jan 15, 2012 1:06 pm

OK. You shouldn't need to run it again after auto importing, only if you do any manual imports and then unless you do a big import it will only need to add the new hands to the cache so it shouldn't take so long in future.

PT4 handles all housekeeping as part of the import process, so this kind of issue won't apply.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests