GiedriusZ
08-06-2011, 10:53 AM
Hello!
The other day I was thinking of ways of how to improve the hand history import speed and one thing came to my mind.
Let's say you start with a fresh database. You have over 3 million exported HH's. While the easiest way to get this done would be just simply to import the whole chunk of hands and live with it, doing this makes the DB huge and the importing speeds drops down dramatically.
So what if, instead of keeping the 3kk HH's (I have bought/dl'ed them from various sources. My alias has only about 30k hands at the moment cause I've started fresh in another room), I would import them and then purge them. As far as I know purge only removes the hands, but keeps the player stats (I don't really care about having the actual hands, all I care is the correct player stats showing up at the tables). This would allow me to keep the database small (since we don't have the actual hands) and have track of all the players.
Is this actually possible? Will the database be smaller after I purge the hands? Will this preserve my importing speed (On a fresh DB I get up to 200h/s and once it hits somewhere around a 1kk hands the import speed drops to like 30-50h/s)?
Will the villain stats be updated as I play more hands with him (Let's say I'm at the table with a player who I have played 100 hands with. During the session we played another 100 hands. The question is, will HEM update the stats to 200 hands or will it not since I've purged his previous hands?)?
Tell me what you guys think of this. Is it worth it?
Thanks!
The other day I was thinking of ways of how to improve the hand history import speed and one thing came to my mind.
Let's say you start with a fresh database. You have over 3 million exported HH's. While the easiest way to get this done would be just simply to import the whole chunk of hands and live with it, doing this makes the DB huge and the importing speeds drops down dramatically.
So what if, instead of keeping the 3kk HH's (I have bought/dl'ed them from various sources. My alias has only about 30k hands at the moment cause I've started fresh in another room), I would import them and then purge them. As far as I know purge only removes the hands, but keeps the player stats (I don't really care about having the actual hands, all I care is the correct player stats showing up at the tables). This would allow me to keep the database small (since we don't have the actual hands) and have track of all the players.
Is this actually possible? Will the database be smaller after I purge the hands? Will this preserve my importing speed (On a fresh DB I get up to 200h/s and once it hits somewhere around a 1kk hands the import speed drops to like 30-50h/s)?
Will the villain stats be updated as I play more hands with him (Let's say I'm at the table with a player who I have played 100 hands with. During the session we played another 100 hands. The question is, will HEM update the stats to 200 hands or will it not since I've purged his previous hands?)?
Tell me what you guys think of this. Is it worth it?
Thanks!