Question about holdem_cache table

[Norman777]

When I wrote an SQL-query using table holdem_cache I saw that this table includes not all hands but last 12-13k hands for me. So is it a way to get stats(for example check/raise flop) using this table if I want to get stats for all hands in database?

[kraada]

The cache table in PT3 includes all hand data that has been cached -- you can see the cache status in the lower left hand side of PT3.

[dav1to]

Hello an aditional question.

The Holdem_chache table what does it exactly contain?
- is it the stats per player per table?
- when do they get loaded in the holdem_chache
- when do they again get cleared..?

[WhiteRider]

Assuming that you mean for PT3 the cache contains pre-calculated values for columns which are used in player stats. The cache table is updated automatically during auto imports, or manually via the housekeeping functions. It is not cleared except as part of a cache rebuild.