[mittelhauser]

Juk,

Just a quick update (both good and bad). The good first...

I have spent a fair amount of time working on the performance of PokerDaVinci after your question (profilers are your friend!). In terms of parsing performance, I have been able to speed up the base performance and fix the issues to ensure that it is basically O(n) now. I just ran a test where I imported 250k PokerStars hand histories. In round numbers, it takes around a minute/1000 hands of history. This was true at the start and at the end (the last 120k took 2h10min). My memory use also remains fairly constant (although the DB memory footprint grows agressively depending upon your settings).

The bad? First off, I have spent so much time on performance testing (which is slow) that I have neglected the core code and I am needing to push the next release back. My new release target is March 15th.

Second, I store a LOT more data about each hand than something like PT does. This means that the DB gets larger. Now that I am doing more extensive performance testing, I have a better feel for it. My 250k hands means a 1GB database file. The current DB I install (MS SQL 2000 Desktop edition) limits you to 2GB which would mean ~500k hands. There are a lot of solutions to this but they will all take some work (for either me or the user)...One option is to just upgrade to SQL Express 2005 which raises the limit to 4GB which would give approx a million hands of history. Another option is to support PostgreSQL in addition (or instead) of MSSQL since it has no limit. Obviously if the user has access to a full licensed version of MSSQL, they can use that instead with no limitations.

-Jon