How to combine cache with new data

[skyd1v3r]

Hello,

I am not sure if I got the right place to post this question, but since it´s SQL...
Please feel free to move it to wherever you belive it belongs to.

I am experimenting with SQL and the command-line-thing. But while I can both read the cache for speed, or fire the actual query for accuracy, I cannot combine both for speed and accuracy. I guess PT reads the cache first, and ther reads the new stats that are not yet in the cache. Is this approach closed-source, or is there some documentation?

Once it worked out, I´ll publish some of my work.

Thanks in advance.

[kraada]

You've got the right idea. The queries are dynamically generated so I can't actually explain how each query is going to work in complete detail, but the key piece of information that you are likely missing is that in the settings table, there are two key settings:
cache_update:holdem
and
cache_update:tourney_holdem

The former is the id_hand for the last hand that was included in the last cash games cache update, the latter is the id_hand for the last hand for the last hand that was included in the last tourney cache update. You should be able to use that value to get the proper values by summing the new data and adding the cache values.

[skyd1v3r]

... but the key piece of information that you are likely missing is that in the settings table, there are two key settings: cache_update:holdem and cache_update:tourney_holdem

That is exactly what I was looking for.
Thank you!

[kraada]

You're welcome :)