DeepBlue
05-06-2010, 07:40 PM
I am hoping someone in engineering can answer this. How exactly does the querying work for HUD stats?
I.e., is the HUD asking for each stat to be updated for each player in a separate query, like is it doing a SELECT for each stat for each player on the table, or is it doing a select per player (and including all stats in the select statement)?
Is it doing more than select, i.e., where do the stats get calculated - on the fly when new hands are imported by a trigger on the database, or does the HUD's query do this in realtime (either triggering a new value of the stat to be stored, or doing the calculations in real-time, the latter of which I would doubt)?
Finally, does it request the stats EVERY hand, or does it do it less often when players have say 100 or 1k hands on them, and thus stats don't really need to be updated every hand?
Basically I am just trying to figure out how many queries per hand are actually being sent over the wire.
I.e., is the HUD asking for each stat to be updated for each player in a separate query, like is it doing a SELECT for each stat for each player on the table, or is it doing a select per player (and including all stats in the select statement)?
Is it doing more than select, i.e., where do the stats get calculated - on the fly when new hands are imported by a trigger on the database, or does the HUD's query do this in realtime (either triggering a new value of the stat to be stored, or doing the calculations in real-time, the latter of which I would doubt)?
Finally, does it request the stats EVERY hand, or does it do it less often when players have say 100 or 1k hands on them, and thus stats don't really need to be updated every hand?
Basically I am just trying to figure out how many queries per hand are actually being sent over the wire.