Database question

[McNeese72]

My stats load real slow, even when filtered for just one month. A lot slower that PT3 did.

Looking I noticed that my PostgreSQL version is 8.3.9. Should I upgrade it to version 9.0 to increase performance? Note: I know not to upgrade to v. 9.1.

Doc

[kraada]

9.0 will probably work a little better - are you on a 64 bit system? If so upgrading to 9.0-x64 will provide a considerable boost.

[McNeese72]

9.0 will probably work a little better - are you on a 64 bit system? If so upgrading to 9.0-x64 will provide a considerable boost.

Thanks, that was my next question. Should I get the 64 bit version since I have a 64 bit system. But you answered it.

Doc

[McNeese72]

Okay, I know a lot of this is determined by my computer but is it normal for the stats in PT4 to take a lot longer to load than PT3 did or is it just my system?

I decided to time how long it took for them to load. I have a database of 451,000 hands and when I clicked the View Stats tab with the top filters set on Report: Summary, Group by: Table Session, it took 3:53 to load. If I then click on the Date filter to this month, it took 1:50 for it load 2,318 hands.

Is this normal times or do I need to look for something on my computer/database/PT4 that might be slowing things down?

It is just annoying because it never took so long in PT3.

My laptop is about a year old and the processor is an Intel Core i5 M480 @ 2.67GHZ 2.67GHZ. The operating system is 64bits and the system has 4GB of ram.

Thanks,
Doc

[kraada]

The 1:50 for this month's 2318 hands definitely sounds too long. Could you attach your PokerTracker4.log file to a support ticket for us so that we can investigate the query details further for you?

[McNeese72]

The 1:50 for this month's 2318 hands definitely sounds too long. Could you attach your PokerTracker4.log file to a support ticket for us so that we can investigate the query details further for you?

Will do. Other than this loading problem, I'm loving PT4

Doc