[Nibster]

[ QUOTE ]

Second, I store a LOT more data about each hand than something like PT does. This means that the DB gets larger. Now that I am doing more extensive performance testing, I have a better feel for it. My 250k hands means a 1GB database file.

[/ QUOTE ]

That seems like a lot of space for 250,000 hands. I think with datamining that would be too much, but since datamining will be non-existent for most users you may get lucky. 1 gb still seems like a ton of space for that many hands. I haven't looked at the database, but are you duplicating the data in different tables? When I look at the HH half of it is just the names of the players. I would have thought with a good data model, once you get the names of the players in the DB the amount of space used would be rather small for each HH. But, I haven't dug into it like you have so I'm probably wrong.