Performance in Reports still poor in comparison to HEM1

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Performance in Reports still poor in comparison to HEM1

Postby ElHive » Thu Jul 26, 2012 5:27 pm

Why is it that PT4 is still performing poorly in comparison to HEM1?

I have the same hand histories in a HEM1 DB and in a PT4 DB which are a little less than 110.000 hands. While filtering in HEM1 takes only seconds it feels like ages in PT4. Though I have to differ between Graph, overview data and tournament table. Graph is instantly reday while overview and tournaments take at least a minute to filter.

At first I thought it might be live scanning from ESET NOD 5 so I excluded postgres.exe, pg_ctl.exe and pokertracker.exe from scanning but it is still sloooooooow.

And don't tell me its my machine. Its a Core i7 with 7200 RPM HDD and 6 GB Ram.

I mean its only 110K hands. What are people doing with 1 Million oder 10 Million hands? Wait days when they wanna know how they did?
ElHive
 
Posts: 51
Joined: Fri Jun 20, 2008 7:30 pm

Re: Performance in Reports still poor in comparison to HEM1

Postby kraada » Thu Jul 26, 2012 5:48 pm

It shouldn't take longer than seconds to load based on what you describe.

Could you please restart PT4 with Logging Enabled, reproduce these slowdowns and attach your PokerTracker4.log file to a support ticket for us? That will show us your query times and we can tell a lot more what might be going on here. You can find your log file by clicking File --> Open user Data Folder in the main PT4 window after running the reports. The file we need is the text file called PokerTracker 4 in the window that appears.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Performance in Reports still poor in comparison to HEM1

Postby ElHive » Thu Jul 26, 2012 6:13 pm

Ticket-ID is 124402
ElHive
 
Posts: 51
Joined: Fri Jun 20, 2008 7:30 pm

Re: Performance in Reports still poor in comparison to HEM1

Postby tarix » Fri Jul 27, 2012 1:41 am

ElHive wrote:At first I thought it might be live scanning from ESET NOD 5 so I excluded postgres.exe, pg_ctl.exe and pokertracker.exe from scanning but it is still sloooooooow.


For EST NOD you want to exclude the entire Postgres directory. On of the following should be in your exclusions:
C:\Program Files\Postgres\*
C:\Program Files(x86)\Postgres\*

The star on the end is important so that it doesn't scan every single time you try to do a database query.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: Performance in Reports still poor in comparison to HEM1

Postby schlauf » Fri Jul 27, 2012 8:15 am

Excluding the above mentioned applications and folder in kaspersky drastically reduced loading time for me.
schlauf
 
Posts: 9
Joined: Sat Apr 14, 2012 12:17 pm

Re: Performance in Reports still poor in comparison to HEM1

Postby pt4pt4pt4 » Fri Jul 27, 2012 8:44 am

where do you exclude this?
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Performance in Reports still poor in comparison to HEM1

Postby kraada » Fri Jul 27, 2012 8:46 am

Are you using Kaspersky or EST NOD?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Performance in Reports still poor in comparison to HEM1

Postby pt4pt4pt4 » Fri Jul 27, 2012 8:51 am

sorry i thought this was an interanl command within Postgres
pt4pt4pt4
 
Posts: 1097
Joined: Fri Feb 03, 2012 12:17 am

Re: Performance in Reports still poor in comparison to HEM1

Postby kraada » Fri Jul 27, 2012 9:20 am

Nope, we're talking about telling anti-viruses it's ok not to scan every database file every time it's read or written :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Performance in Reports still poor in comparison to HEM1

Postby ElHive » Fri Jul 27, 2012 11:12 am

I exluded the following directories from Realtime Data Protection:

C:\Program Files (x86)\PostgresSQL\*.*
C:\Users\Thorsten\AppData\Local\PokerTracker 4\*.*
E:\Poker\PokerTracker 4\*.*

It is still slow

Even if i deactivate ESET NOD it is still slow. So my guess is it has nothing to do with ESET NOD.

Suggestions?
ElHive
 
Posts: 51
Joined: Fri Jun 20, 2008 7:30 pm

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: Amazonbot and 35 guests

cron
highfalutin