Because you've got the "Mucked Cards" window open, perhaps.
A few people have asked this recently. The problem has been something I haven't been able to reproduce. Until now, perhaps. When the Mucked Cards window is not open, Poker Copilot doesn't bother updating its contents. With it IS open, then Poker Copilot regularly needs to update the window, which means more database work. It seems this particular database work becomes increasingly slow as your number of hands increases.
I'm investigating why this is the case. But for now, the simple solution is to close the "Mucked Cards" window until all your hands are loaded. If you do have this problem, please post in the comments whether this solves the problem.
And now for the techies: yep, the SQL is optimised and using two simple single-column indices/indexes. Yep, I've checked for full table scans, and nothing evil like that seems to be the cause. This might (but only might) be a regression caused by when I updated the H2 database engine.
Tomorrow, when I'm coffee-d up and alert, I'll find a much faster way to get the mucked cards info out of the database.
The Poker Copilot Blog
Tracking the development of Poker Copilot, Mac OS X software for poker analysis and statistics.
Thursday, 15 April 2010
Why has the Poker Copilot import become so slow?
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.
Blog Archive
-
▼
2010
(247)
-
▼
April
(34)
- Poker Copilot 2.42 Now Available
- Brief Bursts
- From the Blog Comments
- The Benefits of an Established Blog
- Pleasant Error Handling and Nasty Error Handling
- Using Poker Copilot's "All-in Equity" Chart
- No HUD and No Data on Full Tilt?
- Poker Copilot 2.41 Now Available
- New Look Poker Copilot Hand Replayer
- PokerStars in French, Bulgarian, Latvian, ...
- Pocket Pairs Leak Detector
- Blind Stealing Leak Detector
- PokerZebra 0.5: Now with Ranges
- A Bleg for Links
- Whoah.. Strange PokerStars Tournament Buyins
- The Ten Minute Website with iWeb, Dropbox, and Go ...
- Why has the Poker Copilot import become so slow?
- Coming in the next Poker Copilot update: Start a N...
- New Poker Copilot User Guide Available
- Poker Copilot 2.37 Available
- Today's PokerStars Update Broke Poker Copilot
- PokerZebra 0.4: Now with "random"
- Need Tech Support? Find a Kid
- You are breaking my heart, Apple
- All-In Equity Value Chart Preview Ready for Downlo...
- Java Swing Test Frame
- Are Hold'em Manager's All-in Equity Value Calculat...
- HELP! All-in Equity Value Difference Calculation
- The Poker Copilot Leak Detector
- Something for PC similar to Poker Copilot
- An Easter Special: Poker Copilot for $49.95
- Tournament Chips get their Own Currency Symbol
- "Where's the Darn All-in EV Chart?"
- Mac Poker: The State of Play in French
-
▼
April
(34)


3 comments:
fine, but don't forget the starring feature in it ;) :)
Hi Steve,
My 5000 files took two days to load. Not a big deal I guess. For the sake of adding to your data I'm willing to reset my database and load it again with the mucked hands window closed to see if it makes a difference. Wish me luck.
Mission accomplished. After I closed the mucked hands window it went MUCH faster.
Thanks for solving this problem. We appreciate your efforts.
Post a Comment