Poker Copilot’s 150K hand limit overcome

Poker Copilot’s power users often ask me to remove the 150,000 hand limit. Overcoming this for version 2 has required lots of changes to Poker Copilot’s database engine. As you can see in the screenshot, I now have 500,000 hands in my test database:
In close-up:

Storing 500K hands requires about 2 GB of disk space.

There’s been some technical challenges in adding this while keeping Poker Copilot’s speed. I’ve used every database performance trick I could find: denormalising data, removing unused data, creating pre-built data summaries, using multiple threads. The result seems satisfactory. Or, as we say in IT technical jargon, it’s butt-kickin’ wicked fast.