Purge

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

Moderator: Moderators

Purge

Postby MrFlibble » Tue Jun 10, 2008 4:16 pm

I know there is no purge feature yet built into PT3, but I'm slowly running out of space. I'd like to purge the oldest hands/stats from the DB. Have you guys got a query in the works that will do something like this? Any chance of a preview?
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

Re: Purge

Postby MrFlibble » Wed Jun 11, 2008 1:11 pm

Bump - rapidly getting lost in the archives...

How involved would a query like this be...something a wee end user could attempt if pushed by necessity?
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

Re: Purge

Postby kraada » Wed Jun 11, 2008 1:47 pm

There is a complete purge (Databases --> Database Management --> Purge) that deletes the entire database's contents. There is not yet the ability to selectively purge. This is planned, we are certainly not going to forget about it.

Unfortunately I don't have a great grasp on the SQL involved so I can't hazard a guess as to exactly how to do it. I do understand it's a relatively complicated function though.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Purge

Postby WhiteRider » Wed Jun 11, 2008 2:00 pm

Yes, very complicated - you can't just remove a single hand as everything is tied to all the players in the hand, and the rest of the session too.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Purge

Postby MrFlibble » Thu Jun 12, 2008 9:06 am

Ok. It it likely to be a long time (more than 2 weeks) before I can see a query to do this?
I can buy a hard drive in the mean time to cover me, but if its going to be months before I can purge I'm not sure what to do.
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

Re: Purge

Postby kraada » Thu Jun 12, 2008 11:59 am

It will certainly be at least a week. Beyond that it's somewhat hard to tell.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Purge

Postby WhiteRider » Thu Jun 12, 2008 12:44 pm

I think this issue has fairly high priority, so it shouldn't be "months"..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Purge

Postby MrFlibble » Mon Jun 16, 2008 8:56 am

Sorry to be a nagger, but has there been any progress in this?
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands

Re: Purge

Postby WhiteRider » Mon Jun 16, 2008 9:12 am

kraada wrote:It will certainly be at least a week. Beyond that it's somewhat hard to tell.

It won't be until after the next release I'm sure, because there are still HUD stability issues to fix.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Purge

Postby MrFlibble » Tue Jun 17, 2008 6:57 pm

Cheers WhiteRider.
I've started a thread in the SQL forum in the hopes that we can get one together earlier. viewtopic.php?f=18&t=7898
MrFlibble
 
Posts: 58
Joined: Sat Mar 08, 2008 7:30 pm
Location: handhq.com for datamined hands


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests