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?

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.

3 comments:

t181241 said...

fine, but don't forget the starring feature in it ;) :)

Shick! said...

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.

Shick! said...

Mission accomplished. After I closed the mucked hands window it went MUCH faster.

Thanks for solving this problem. We appreciate your efforts.

 

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