Page 1 of 1

PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:13 pm
by pmania
Since I imported alot of hands PT3 seems slow it also seems it hangs. Cause when I first loaded all the player names it took a while to load them all in the Texas Holdem tab. Now I changed something with filters to only today and it loads quicker with much less players ofcourse.

I needed to import some hands which HM didn't do correctly. And now I am trying to export these hands but when I go Database Management a window pops up called: Export - Database: PT3 DB (Not Responding). When the window pops up my processor goes to 25% and stays there and memory cause up to more then 807824K and then goes back to 807824K and the not responding appears and red crosses on the top right for all the windows.
Can I do something about this maybe with filters too ?

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:26 pm
by kraada
What version of PT3 are you currently using? Do you have your cache at 100%?

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:45 pm
by pmania
3.11 yes

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:48 pm
by kraada
How long did you let the export run? Sometimes exporting can take a while and when PostgreSQL is doing the thinking PT3 can appear to not respond but things can still complete properly.

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:51 pm
by pmania
I didn't get to that point at all, when the pop up window opens I see that it wants to load all the players. But it doens't ever show a player, it goes to not responding after a while.

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:55 pm
by pmania
Hmmm wait it does show player names now, but poker tracker shows also as not responding. Memory went up to almost 1 gig

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:56 pm
by kraada
Let it keep going, it will finish.

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:57 pm
by pmania
I clicked on it since the mouse cursor was doind circles and now it went overbright.

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 1:59 pm
by pmania

Re: PT3 slow with 5mil hands

PostPosted: Sun Apr 17, 2011 2:13 pm
by kraada
That doesn't matter. The reason PT3 is listed as not responding is because the GUI thread is locked for population. Just wait; PT3 will work through it and begin displaying the data.