cache?

[AAA Donnie]

Hey, I just added the M stat to my hud, as u prob know, and had to change a cpl settings...
Bare with me please.
I previously had the filter set to not display hud stats for players with < a significant sample, so I obv had to change that if I wanted M to show from hand #1... In doing this I realized I also prob needed to change the cache to update every hand instead of every 5 as I had it prior. Then I start loading up some tables to see if it was working . I only got about 4 tables up when my pc started "working very hard." The fan kicked on high and the bottom of my laptop got pretty hot. In short: began overheating.

I checked the task manager (which I do not know much about) and it appeared to be using a ton of resources, memory,etc.
I was worried about how hot it was getting. So I literally sat out of my tables and shut down my pc for a few min to cool.

After restart I now have 6 tables and have been playing a while without PT3 running and the problem hasn't recurred.

I'm not a pc expert by ANY means, but it seems that the addition of that stat caused this. I was afraid to restart PT3 because I can't "afford" to sit out again. (just in case obv)

So my actual questions are:
Am I right?
I don't know enough about pc's to know exactly what mine is capable of handling , so to speak. I play on my Vaio laptop.
It was expensive and "nice" about 2yrs ago, but will this stat be too much abuse for my pc than it's worth?
Has anyone else had similar issues?
I didn't even use the browser...but w/ FTP's memory hog, crap software, and my software like Table ninja, this...
am I asking for trouble?

Any input is greatly appreciated! TYVM

[AAA Donnie]

One other thing I forgot. After adding the M stat, I updated the cache. It was taking a cpl hrs and was only a few % complete, so I restarted everything. When restarting PT3 and updating the cache, it took 5 sec. ??? I thought I had screwed up somehow, but when I loaded up the tables, the stat came right up and seemed to work fine. ?? I then started changing colors of the hud stats when I had the previous problem. Did stopping the 1st cache update possibly screw anything up?

Thanks

Edit: What I changed in the hud settings was the refresh rate to 1. (You prob figured that tho)

[kraada]

You added the M stat from this thread, correct? It's known to cause initial cache times to take a very long time - I haven't had a chance to investigate further to see what happens when you end it prematurely then try again, but I suspect your cache may possibly be corrupted. You can fix it by running a Cache Rebuild, but again, expect it to take a long time (I'd recommend starting it before you go to bed and then by morning it should be done).

[AAA Donnie]

Ohhhh, interesting. I'll wait until tonight to try then.

Will the addition of these stats add significant "stress" to my pc?

[WhiteRider]

I wouldn't expect so - I haven't looked how they work in any detail, but I'm pretty sure one or two of these won't make any difference, and the any 'normal' stats built from these (i.e. not "live" stats like M) that are in the cache shouldn't cause any significant work.

[AAA Donnie]

Thanks. I don't want u to have to keep jumping around in my multiple threads... VERY Sorry!
I was really tired when I was trying to figure all this stuff out and wasn't getting any replies in email cuz they were going into spam :oops:

Any significance to the things I stated here? viewtopic.php?f=18&t=29375
Mere coincidence?

TYTY!

[kraada]

You've got a reply in that thread.

[AAA Donnie]

TY!
I have a support ticket in for my postgres upgrading issue, but can we please re-visit my db issues in this thread?

I think I really screwed up somewhere. Maybe when I deleted those db's in pgAdmin???

I looked through my data in the PT3/tourney tab and realized that I am missing a lot of info on other players.

My personal data seems correct, but I am missing 1,000's of hands with other players. (One player specifically I have like 10,000 hands with, it shows I have like 400) :cry:

I don't even know where to begin to troubleshoot this. :?:

To my knowledge, I only had 1db in PT3 that I used. Possibly 2. But, all of my info was in the one. "My custom db" before I started screwing around w/ pgAdmin and SQL.

Please help. I am dying without a hud for days now. :cry:

[AAA Donnie]

Also, I have all of the hh still in the processed folder. But I don't know how to re-import them.
I did my backup,zip,archive from there also. But I must not be restoring correctly :?:

[WhiteRider]

If you only had one PT3 database then you can't have deleted it, but it's possible you had a second database set up for observed hands and deleted that? I remember from your ticket that you said you saw your PT2 databases with red Xs next to them - until you actually connect to a database they all have red Xs (apart from the 'postgres' database) so it's possible you deleted the wrong one.

To re-import the hand history files from the Processed folder use Manual Import. Any hands which are already in your database will be ignored, so this is safe.
If you import a lot of hands then you should Rebuild Cache (Database > Housekeeping) but if it is only a small amount relative to what is already in your database then Update Cache will be faster - either way, make sure the cache status shows 100%.