Table Tracker Optimization - PokerTracker

Two Plus Two Forums Archived Forums Sponsored Support Forums PokerTracker

Table Tracker Optimization

...

06-30-2008 , 02:27 PM

garvin

centurion

Join Date: Feb 2006 Posts: 119

I hope you realize Table Tracker will need some optimization, such as either a cache or some kind of aggregator ability (e.g. as some others products). Even with a DB only some 300-400k it takes to long too make a search, and with a large DB with millions of hands its not usable. Maybe its possible to get a fast search with basic data, and then retrieving additional data, eliminating JOINs over table which takes time.

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

06-30-2008 , 03:05 PM

Kraada

See our Commercial Software thread

Join Date: May 2005 Posts: 6,489

We are aware there is plenty of room to optimize these queries, and it is definitely on our to do list, however it is not (at the moment) at the top of our to do list (that is HUD stability, then new site support, followed by features from PT2 that are not currently in PT3).

But we will get there

07-01-2008 , 03:49 PM

garvin

centurion

Join Date: Feb 2006 Posts: 119

I don't think its about some query optimization.

A table search in table tracker, when using a multi-million hand DB, takes me over an hour (with a good PC).

Doing the same table search, using the same DB and on the same PC, using competing product SpadeEye with its Aggregator functionality enabled, takes 40 seconds.

So if you have to redo the design and match that, might as well start now...

07-01-2008 , 04:19 PM

Kraada

See our Commercial Software thread

Join Date: May 2005 Posts: 6,489

I admit that I do not understand the deep inner workings of Table Tracker, but what I do know is that we will keep working to improve Table Tracker and all aspects of PT3. If cache functionality is required in order to speed things up to an acceptable level, we will add one. At the moment our main development team is working to fix known HUD issues, and our Table Tracker team is working to implement PokerStars support. But we will improve responsiveness of this portion of the program.

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

...