The TalkingPoker.com Forum  

Go Back   The TalkingPoker.com Forum > All Things Poker > General Poker Discussion
Register Blogs Arcade HH Converter Calendar Mark Forums Read

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 09-15-08, 09:01 AM
melioris melioris is offline
squeezed the charmin
 
Join Date: Nov 2005
Location: Milwaukee
Posts: 3,015
melioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Points
Default database question

I have been thinking about this for a while and I want to get feedback before I do it. I am thinking of deleting my tracker database and starting over. Ok, maybe not deleting, but not using any hh gathered before August 1, 2008. I got this huge database, and I figure that 99% of it is worthless, or worse, misleading. A lot of the regs I play against have adjusted their game over the past 6 months and the number of hands I have against them is so large that those adjustments are hidden by an avalanche of now meaningless HHs.

Thoughts?
  #2  
Old 09-15-08, 09:16 AM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

I have a few thoughts on this, but I'm heading out the door for work - I'll get back to this later today (or earlier if I can grab a few minutes).
  #3  
Old 09-15-08, 11:06 AM
hackers238's Avatar
hackers238 hackers238 is offline
Rock
 
Join Date: Nov 2004
Posts: 477
hackers238 has between 250 and 499 Rep Pointshackers238 has between 250 and 499 Rep Pointshackers238 has between 250 and 499 Rep Points
Default

I read a discussion a little while ago about this, and the consensus seemed to be keeping only the 2000 latest hands. I'll try to dig it up...
__________________
Poker Blog - www.hackers238poker.blogspot.com

Note to Self - Play ABC Poker.
  #4  
Old 09-15-08, 01:15 PM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

2000? That seems silly. Or do you mean only looking at the last 2000 hands from EACH of your opponents? That, I'd buy.
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
  #5  
Old 09-15-08, 08:56 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

OK, I'm back...

I'm assuming we're talking about PT - it's the only manager I have experience with. I'm also assuming you're using postgres for the database engine - if you're not... well, I've ranted on that a few times here already (do a search if needed).

Before you go ahead and create a new database you might consider using the built-in tools to purge the older HH files:

Before you begin - first back it up, then run a vacuum full/analyze

Under Utilities -> Database Maintenance and Options click Advanced Purge. From there you can get pretty specific regarding hands you want to get rid of - in your case a date range is what you're looking for. I've not run this myself, but I would expect it to take a while.

I highly recommend running a separate database for observed hands - you should purge this one as well.

You also have the option of setting a filter on both your PT screens as well as (more importantly) PokerAce HUD. For the HUD it's under: options -> filters - then click the Show Hands From The Last [0 ] hands Only checkbox and put a number in the box (like ~2500 I would guess). That should give you the same effect as the purge.

If you do continue on and create a new database I hope you save your HH files so can import the ones you want. If not, AND you've chosen to store the entire HH file in the database, you can extract them from the database. I'm not sure right now how you'd parse them for date though - there might be a way, but I'm not sure.

For maximum performance of the database - here are a couple of things that I do:

- I run Postgres on a different server - mine is a linux box. This does a couple of things for me - it offloads the SQL processing to another machine and postrgres runs faster/better on linux.
- I keep separate databases for each site and the observed hands for each site. They say you don't have to, but I do - and I believe I get better performance from it. It's a bit more work, but I think it's worth it.
- I run maintenance on my databases very regularly. This keeps the databases clean and tidy and fast - particularly when datamining. Inserting new records into the database is more expensive than reading as the server needs to maintain the indexes - running the maintenance makes this much faster.
  #6  
Old 09-15-08, 08:57 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

Must be - that's the way the filter works in PAhud.
  #7  
Old 09-16-08, 08:43 AM
melioris melioris is offline
squeezed the charmin
 
Join Date: Nov 2005
Location: Milwaukee
Posts: 3,015
melioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Pointsmelioris has between 3000 and 3499 Rep Points
Default

excellent post decoder. I don't know shit about database stuff. While I am appreciative of your post, I was asking more along the lines that sometimes I have a shitload of hands on a player, but i think the player has totally adjusted his game and now the stats are irrelevant yet, since my total hands on the player over the last two years or so is so large, I will never see the adjustment reflected in a change in the stats.
  #8  
Old 09-16-08, 09:26 AM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

It looks like all the purge options are pretty global. You do have the option to selectively purge certain sessions, but it may also purge some of your own details if you were at the same table (not a problem for observed hands though). You might try that. I haven't seen a way of removing a certain number of hands for a certain player.

OK, so if you go to the Database Maintenance And Options you can select a player from the database. It will then display all the sessions that player has played (it's sorted by start time, but you can click on a header and change it). Select the sessions you want to delete (in your case I guess the older ones) and click Purge Session(s). If you only do your observed database you don't need to worry about your own stats (including things like lifetime win/loss and stuff).

That should get you to where you want to be.
  #9  
Old 09-16-08, 12:42 PM
hackers238's Avatar
hackers238 hackers238 is offline
Rock
 
Join Date: Nov 2004
Posts: 477
hackers238 has between 250 and 499 Rep Pointshackers238 has between 250 and 499 Rep Pointshackers238 has between 250 and 499 Rep Points
Default

Yeah, 2000 latest from each opponent. I must have found this in another random forum while browsing because I couldn't find it again.
__________________
Poker Blog - www.hackers238poker.blogspot.com

Note to Self - Play ABC Poker.
  #10  
Old 09-17-08, 12:50 AM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

If this needs to be done manually for thousands of players, I'd rather start from scratch.

Use the freaking PAHud filter. 10 seconds beats the hell out of 100 hours.
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:13 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2004-2008 TalkingPoker.com