Follow-up Comment #2, sr #2176 (project pokersource):
The use case is as follows: a poker room has many currencies (one per month)
and wants to display the best 5 tournaments of a player, with tourney name
name. With the current structure there is a mandatory join between two large
tables (user2tourney + tourneys). If adding the currency_serial to
user2tourney, the an inner select with currency_serial = "thismonth" will
greatly reduce the join.
Deciding if this is a general need or specific to a poker room is a judgement
call. I don't have hard evidence. However, over the past two years the
currency has been used as an elegant way to group users, tournaments and
tables. Using it to cluster information and create monthly groups is another
clever use of currency_serial. It feels like currency_serial acts as a
general group id and therefore participate in so many joins that it is
beneficial to replicate it in most tables.
It is disputable :-)
_______________________________________________________
Reply to this item at:
<http://gna.org/support/?2176>
_______________________________________________
Message sent via/by Gna!
http://gna.org/
_______________________________________________
Pokersource-users mailing list
[email protected]
https://mail.gna.org/listinfo/pokersource-users
