I implemented this and sure enough, the size reduction is dramatic. I also changed a couple of the double precision number fields to single precision (you don't need double precision for, oh say, exchange rates). I changed some LongInteger's to Integer's as well (I don't think anyone is going to play more than 32k hands in one session ).
Instead of doing a linked database conversion, I created a new master blank database and re-imported hand histories into that.
I've brought this concept up to the PokerTracker folks and we'll see what the response is from the smart guys.
Nice post Schro.Statistics: Posted by gdaviet — Sun May 29, 2005 5:31 pm
]]>