![]() Situations that you may want to remove Poker Copilot 3.2 When there is a need to uninstall Poker Copilot 3.2 on your Mac computer, do you think it is just a piece of cake or a difficult task for you? Different people may give different answer to this question, but it is a fact that some problems always exist and trouble you to remove this app under the OS X. If you further restrict the date range of player data to, say, six months, and it is even faster, in many cases down to less than a second, which is usable performance, I think.How can Uninstall Poker Copilot 3.2 Totally from Your Mac It turns out that by filtering out all players who you haven’t seen in the last 30 days, we can filter and summarise those 10 million rows of information in your database in a few seconds. But for people you haven’t seen for weeks or months? Not important for improving your poker game. For the players you’ve played against today, you want to see their all-time statistics. In fact, mostly just the current session is important. One idea that kept running through my head is that you typically only care about the players you’ve seen in the last few days. So I’ve been thinking of changes I could make in Poker Copilot for a faster Player summary, while keeping it useful. We can’t even assume that your computer has plenty of RAM (Although note: the best way to make Poker Copilot run faster is to increase your computer’s memory).Īnother common solution is to use some summary tables prepared in advance. Poker Copilot offers arbitrary filtering on almost any conceivable characteristic of a hand, which means that for this particular screen we can’t have the data already summarised we need to do it on demand. In a desktop app we can’t be so generous in using up all your computer’s memory. Give it enough RAM to hold the entire database to memory and you’ll get sub-second performance. On a stand-alone, dedicated database server, you could simply give the database server a beefy CPU and plenty of memory, and the problem would go away. To show you information for the players in your database, those 10 million rows need to be speedily read, filtered, summed, and sorted – all in a desktop app with an embedded database. ![]() We store these hands in a database table, one row per player per hand. The basic problem was this: you may have a million hands in your database, with up to 10 players per hand. ![]() For a large database, with the date range set to “All time” it could take a minute or two. I modified it to make it more correct, but in the process it became slow. Last year, while working on improvements for Poker Copilot 5, I found that the Player summary in Poker Copilot was not including all the data that it should be including. It will, however, show all-time data for those players. This fixes a bad performance problem. Summary: as of the next update of Poker Copilot, the Player summary will only show players you’ve seen in the last 30 days. ![]() Change to “Player” Summary in next Poker Copilot update The next update of Poker Copilot is due to be released this week, and will have this performance improvement, as well as some others I’ve been working on. (For the technically minded, and also for any H2 google searches: I increase QUERY_CACHE_SIZE to 100, instead of the default value of 8.) I set it to a much higher value, and it is like I discovered I’ve been driving up to now with the handbrake on. A default performance setting was by default set too low. ![]() Today I discovered that H2, the embedded open source database engine that Poker Copilot uses, was spending too much time analysing each SQL statement before performing it. In recent weeks I’ve been using an excellent developer tool called Java VisualVM to find the parts of Poker Copilot that hog the computer’s CPU, and use the most memory. Now it is toils away at more than 300 hands/second. Before the change, Poker Copilot would load about 200 hands/second. The improvement results in a sustained 50% increase in speed. I’m astonished at how potential performance improvements can hide in software year after year. Today I discovered a small tweak to make Poker Copilot zoom through loading hands into your database. Next Poker Copilot update loads your hands 50% faster ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |