The Poker Copilot Blog

Tracking the development of Poker Copilot, Mac OS X software for poker analysis and statistics.

Sunday, 12 April 2009

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.

7 comments:

Anonymous said...

Well done, when will there be a first beta test release?

Steve McLeod said...

> when will there be a first beta test release?

I don't know yet - still a lot to do!

Anonymous said...

Have you played that much Steve ?

Steve McLeod said...

> Have you played that much Steve?

I wish! With all the time I spend developing Poker Copilot, I could never play 500K hands!

KeithX said...

Sounds great! What sort of database are you using?

Steve McLeod said...

> Sounds great! What sort of database are you using?

H2, an embedded Java SQL database.

George Smeros said...

probably the best update so far !!
i hope we will see it in the next update.

 

Poker Copilot

Free 30 Day Trial

Only $69

Order risk free with our 30-day money back guarantee.

  • Poker tracking software for Mac OS X
  • Supports PokerStars, Winamax, Merge Network, Ongame Network
  • Analyses your opponents while you play
  • On-table HUD for Mac
  • Easy to use, easy to understand

Watch a demo of the major features of Poker Copilot