![]() |
|
#1
|
|||
|
|||
![]()
Because if you use several databases for several sites, you will inevitably import hands in the wrong database at some point. If you have 10 databases for different sites and different limits you'll go crazy. It's also pretty much useless ... in PT you can specify you only want to see stats from limit x and site y ...
All my hands are in the same database. As for observed hands, I put them in a separate database. For 2 reasons. First, those hands won't slow down PT when I look at my own stats since they are in a separate Db. Also, because I want to be able to delete old observed hands after a while. After a year or so, the observed hands are pretty much useless ... I won't see the same players and if I do, they will play differently. If the observed hands are in 'your' database, you'll have a hard time to delete old observed hands ... So I create a new observed database every quarter. 2006-Q1 2006-Q2 2006-Q3 2006-Q4 When I create 2007-Q1, I will delete 2006-Q1 |
#2
|
|||
|
|||
![]()
Good post C.
|
#3
|
|||
|
|||
![]()
I have one database for "my hands".... then separate databases for "observed hands" at the different sites.... that works well for me, but I do have to be careful to not mix up the db's when i'm importing hand histories
|
#4
|
|||
|
|||
![]()
Why bother to seperate your observed hands and your own hands into seperate DB's ?
|
#5
|
|||
|
|||
![]()
I used to have everything in one db, but that db was getting big and slow when I wanted to analyze my ring stats for example. So the idea was to keep each db a more manageable size that wouldn't take too long to analyze stats with, etc. I have also purged the observed hand db's of the lower limits that I no longer play to keep them more manageable in size as well.
|
#6
|
|||
|
|||
![]()
[ QUOTE ]
I used to have everything in one db, but that db was getting big and slow when I wanted to analyze my ring stats for example. So the idea was to keep each db a more manageable size that wouldn't take too long to analyze stats with, etc. I have also purged the observed hand db's of the lower limits that I no longer play to keep them more manageable in size as well. [/ QUOTE ] I just create a new DB each month now, with the new caching feature in PAHUD you can link multiple database together and it adds stats together. So in my new DB I may have 10k hands and my old database my consist of 5million hands and on the table the stats of the players will be combined and you'll still see lets say 15k hands on a player. This allows me to see and analyze my game each month and it doesn't take forever either. |
![]() |
|
|