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.
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
Subscribe to:
Post Comments (Atom)
Poker Copilot Translation Project
Want to use Poker Copilot in your language? Then help with the Poker Copilot Translation Project.
About This Blog
In May 2008 I started working on Poker Copilot, initially as a product to help me with my own poker playing. Soon I joined a "30-day Challenge", where the participants each aimed to launch a software product in 30 days. As a result of this challenge, Poker Copilot version 1.0 was launched in July 2008.
This blog tracks the ongoing development of Poker Copilot. Who would find this blog interesting? People interested in 1-person software development, in Poker, or in both.
Contact me via email at steve at pokercopilot dot com.
This blog tracks the ongoing development of Poker Copilot. Who would find this blog interesting? People interested in 1-person software development, in Poker, or in both.
Contact me via email at steve at pokercopilot dot com.
Blog Archive
-
►
2012
(96)
-
►
May
(13)
- Lock Poker News
- What do MP, EP, CO mean in the positional stats?
- Adding a new Ongame Network poker room to Poker Co...
- Adding a new Merge Network poker room to Poker Cop...
- PokerStars on iPad and Poker Copilot
- Lock Poker and Poker Copilot
- Phil Gordon's Little Gold Book and Poker Copilot's...
- Poker Copilot 3.10 Now Available
- Crushing the Microstakes and Poker Copilot's HUD
- Early Access Version of the next Poker Copilot Upd...
- How many hands do I need for Poker Copilot's HUD t...
- Coming soon: PFR by position, Aggression by street...
- Comments on this Blog
-
►
April
(18)
- Important information from 2+2 : Two Plus Two Foru...
- Coming in the next update: VPIP by position
- A Nice Email…in French
- Poker Copilot Tip: Move HUD Panels without the Ful...
- Update for Winamax Users
- Poker Copilot 3.08 Now Available
- Poker Copilot Blog: 1000+ blog posts
- Poker Copilot and Zoom Poker: Update
- Poker Copilot 3.07 Now Available
- A poker player uses Poker Copilot to improve
- Coming in the next update: FALSE filters
- Mockup of Potential Poker Copilot Dashboard Concep...
- A Poker Copilot work-around for Merge Network idio...
- Poker Copilot App Updating
- Carbon Poker has its own HUD! (but only on Windows...
- Improving Poker Copilot's App Updating
- Poker Copilot 3.06 Now Available
- False Assumptions
-
►
March
(18)
- How NOT to make money as a software company
- Zoom Poker HUD Early Access Edition
- Changes to the Poker Copilot Hand Formatter
- Coming in the Next Update: Zoom Stats can be separ...
- Poker Copilot and Zoom Poker: played my first sess...
- The Absurdity of Modern Life: Facebook claims trad...
- Poker Copilot and Zoom Poker: Progress Update
- What character is that?
- PokerStars screen names
- Poker Copilot and Zoom Poker
- Poker Copilot 3.05 Now Available
- Ongame and Table Size
- Updated Poker Copilot User Guide
- Coming in the next Update: Unopened PFR Statistic
- Poker Copilot 3.04 Now Available
- Google Analytics Update: Almost a Good Graph
- Poker Copilot Website in Russian
- Downloading Older Poker Copilot Updates
-
►
May
(13)
-
▼
2009
(337)
-
▼
April
(21)
- Sentence of the Day
- Poker Copilot: Worst Day Ever. Best Day Ever.
- Adobe. Fireworks. Activation System. Sigh.
- Yet Another Poker Copilot Update for Full Tilt
- Poker Copilot 1.70 Now Available and Highly Recomm...
- Today's Full Tilt Update breaks Poker Copilot
- Coming in Version 2: Improved Players Summary
- Poker Copilot Reviews in German and Russian
- Seriously Good Mac FTP Software
- A Pair of Aces Twice in a Row?
- The Life You Can Save: Chapter 2
- Dependent on Poker Copilot
- Pencil and Paper are SOOOO 2007
- Poker Copilot updated today
- Poker Copilot's 150K hand limit overcome
- Do German Programmers Dream in English?
- MacZOT results
- Poker Copilot 50% off on MacZOT
- Search Traffic Overtakes Referrals Traffic
- Sentence of the Day
- Price Sends a Signal
-
▼
April
(21)


7 comments:
Well done, when will there be a first beta test release?
> when will there be a first beta test release?
I don't know yet - still a lot to do!
Have you played that much Steve ?
> Have you played that much Steve?
I wish! With all the time I spend developing Poker Copilot, I could never play 500K hands!
Sounds great! What sort of database are you using?
> Sounds great! What sort of database are you using?
H2, an embedded Java SQL database.
probably the best update so far !!
i hope we will see it in the next update.
Post a Comment