Because of the translation I don't understand well the sentence where you say:"and in the ways you cannot request more than 1600 cached and uncached columns for your HUD".
I have a HUD where the total number of columns is far higher than 1,600 columns (many repeated), then I do not understand that referred to with this limit in the HUD.
I have endless columns if they are not saved in the cache memory?
When I reach the limit of columns in memory cache, jumps me a warning message or what happens?
I believe that I explained me evil. Not have problem with them values numerical of them positions in the creation of filters and NT, but with the adaptation of the statistics positional according to the variation of the table / players.
As both stated, in a table of 7 position 5 players there, but I have columns such as:
- Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.position =5, 1, 0])
How affects to the statistics when there are 7 players on the table or the type table is 6-max, 4-max, etc?
Stops working just like a filter because there is no 'tourney_hand_player_statistics.position = 5', or is automatically exchanges in "EP"?
What I mean, is that the positions (0, 1, 2, 8 and 9) are unchanged regardless of the type of table and number of seated players.But, I have to do columns similar to the following for positions 3, 4, 5, 6 and 7?
- Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_open_opp AND ((tourney_hand_summary.cnt_players between 4 and 6 and tourney_hand_player_statistics.position between 3 and 5) OR (tourney_hand_summary.cnt_players between 7 and 8 and tourney_hand_player_statistics.position between 4 and 7) OR (tourney_hand_summary.cnt_players between 9 and 10 and tourney_hand_player_statistics.position between 5 and 7)), 1, 0])
How can I check the speed with which consultations are carried out?
Is the speed the same regardless of my pc hardwares?
What is more slower and optimizes query speed?
Being something so deep, is it best to always use "LIKE" instead of "SIMILAR TO"?
I checked it thoroughly and it has columns and also character limit, I guess esto va in relation to point (2).
Some questions are rhetorical, if you find it more convenient you can copy the message and responds within each section and leave blank you want to.