speed of column operation

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

speed of column operation

Postby Leopard » Tue Apr 02, 2024 1:28 am

I heard from my friend that column concerned string operators like lookup_actions_f.action = 'X' speed down work.
So, is there any diffence to work PT4 in two cases below:
lookup_actions_f.action = 'X'
vs
tourney_hand_summary.amt_pot_t = tourney_hand_summary.amt_pot_f

?
Leopard
 
Posts: 25
Joined: Tue Mar 26, 2013 2:58 pm

Re: speed of column operation

Postby Flag_Hippo » Tue Apr 02, 2024 6:49 am

Both queries can use the database cache so there shouldn't be any noticeable difference. Also the two expressions you've given don't do the same thing since lookup_actions_f.action = 'X' is specific to a player wheareas tourney_hand_summary.amt_pot_t = tourney_hand_summary.amt_pot_f is specific to the hand.
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: Iepurila89 and 48 guests

cron