Vern,
Pokertracker Pat has stated that MySQL will be available even before version 3, probably in the form of a version 2 patch.
I have considered your idea. This inexpensive solution is preferable in my mind, as I am a cheap bastard. In fact, I have this setup right now. However, there are some issues with it.
Current Setup in the vein of what you are describing:
Main Computer / Play Computer
-------------------
Athlon 2400+ with 1.5 GB of RAM
Radeon AIW 9600XT with 2 2001FPs running at 1600 X 1200 each.
This computer runs the poker room software and the gametime software, which overlays PokerTracker information over the poker room windows. Windows are spread 4 to a screen (800 X 600 each). It is actually the Play machine that is the most CPU intensive. The poker room and gametime software are, by far, the most taxing applications run.
Secondary Computer / Poker Tracker Computer
--------------------------
Old Pentium 2 850 MHz (Something around there)
Old monitor
This computer has PokerTracker on it. I have set the ODBC to a mapped networked drive on the main machine where the database is located. PokerTracker pulls hand histories from shared folders on the Main Computer and updates the Database on the main computer. PokerTracker doesn?t actually use much CPU bandwidth here. This leads me to believe that the bottleneck might be in the transfer speed or Play Computer CPU cycle unavailability.
---------------------------
That was the theory anyway.
In practice, it doesn?t work for several reasons.
1. My Athlon 2400+ is just a tad too slow for 8 or 9 windows. 7 windows runs well. My solution for this problem would have been to go to Fry?s and get an upgraded motherboard / CPU combo. Probably the Athlon 64 3000+ or something and do an upgrade. This small increase in speed would probably be enough to accomplish the amount of windows I want.
2. The remote PokerTracker imports really slow when there are many poker windows open. It imports at a rate of 1 or 2 hands a minute, which is unacceptable as I generate about 5 hands per minute. I can?t figure out how to speed this up. When I first started, playing 4 windows, it would import hands at a rate of 5.7 per minute. But when I scaled it up the next day that figure dropped to the 1 or 2 per minute I alluded to earlier. Do you have any idea what would cause this slowdown?
Possible bottlenecks would be:
a. not enough bandwidth for transfer over LAN ? this is possible, but the fact that importation slowed down when the Play machine became increasingly taxed for resources would indicate something else perhaps.
b. not enough CPU power on the DataBase machine. ? This seems unlikely as the CPU usage on this machine is always very low.
c. not enough free CPU poker on the Play machine ? is this possible? If PokerTracker is updating a remote database that resides on the Play machine, does this actually take CPU power from the Play machine?
------------------------------
So, why is the database reside on the Play Machine, you might wonder?
Because, the Database importation of new hands does not need to be super fast. It just needs to import at 6 hands per minute, nothing more (which it cannot do at the moment).
However, the gametime software needs to look at the PokerTracker database independently. It overlays this information over the actual poker screen. The problem here is that any delay in this information and it can freeze up the poker room software. When you add this to a room, it freezes up momentarily sometimes. At the wrong time a hand could be folded due to this.
The reason I have the database reside on the play machine is that gametime access needs to be fast. If it is not fast, it can freeze and fold my hands and cost me money. The PokerTracker import does not need to be fast, just fast enough.
If I could somehow figure out a way to speed this remote import, I would be happy with the current system and maybe settle for a new MOBO CPU combo to give it a little extra juice. Are these remote access queries dependent on free resources on the Play machine I wonder?
However, since I can?t seem to get this to work properly, I am considering the higher end computer option instead.
I am not done troubleshooting this makeshift two computer solution yet, however. Perhaps I can make it work yet .
Any ideas?