It doesn't change anything. I still have 300P sitting there, 99% of the time.
Comment has been collapsed.
After a giveaway is created, the site needs to distribute 5% of the value in points to all users. This takes a few seconds, since we have nearly a million users.
If it's implementable, exclude people who didn't logged for a month from points distribution could save some resource ?
Comment has been collapsed.
well, we don't know how people at 300 points are handled
edit, nvm http://www.steamgifts.com/go/comment/dkla7sa
Comment has been collapsed.
Hm, does the site takes accounts with 300P into calculation when distributing the points? You mentioned almost a million user, while active users are considerably less, I've seen lots of profiles with no activity for the past months, years. Filtering out them from the point distribution (as they already have 300 points waiting for them if they'd return) could maybe help in ..some way?
Comment has been collapsed.
Yep, that's all taken into account, and the database only updates users that are changing in points.
Comment has been collapsed.
8,457 Comments - Last post 4 minutes ago by FranckCastle
65 Comments - Last post 20 minutes ago by Fluffster
25 Comments - Last post 38 minutes ago by FranckCastle
5 Comments - Last post 1 hour ago by timmyfromspace
314 Comments - Last post 2 hours ago by Southrobin
368 Comments - Last post 2 hours ago by Navaro
15,380 Comments - Last post 3 hours ago by kolja300314
753 Comments - Last post 1 second ago by Bydydyndi
48 Comments - Last post 3 minutes ago by FranckCastle
64 Comments - Last post 31 minutes ago by at46
5 Comments - Last post 33 minutes ago by Ginohax
203 Comments - Last post 38 minutes ago by LaVolpe99
91 Comments - Last post 48 minutes ago by Naviis
656 Comments - Last post 59 minutes ago by Wintermute101
The Issue
When you create a giveaway there's a delay for 5-10 seconds. Also, when entering giveaways, the site occasionally hangs on the please wait state, or takes a few seconds to go through.
Why Is This Happening?
After a giveaway is created, the site needs to distribute 5% of the value in points to all users. This takes a few seconds, since we have nearly a million users. Since it happens during the giveaway creation process, users wait this few seconds when creating their giveaway.
As for the enter giveaway button, it sometimes freezes due to deadlocks in the database, when it's trying to perform the needed queries to enter the giveaway. Also, if a user creates a giveaway, and you try to enter a giveaway at the same time, there's a delay. The site is trying to distribute points for all users, and you need points removed from your account for entering the giveaway. This creates a delay for a few seconds until points are distributed and your giveaway entry can go through. During peak hours, we might have 5-10 giveaways created every minute. There's a decent chance you click the button to enter a giveaway within a few seconds of someone creating a giveaway, and end up waiting.
Solution
Points are now distributed in 15 minute intervals. Every 15 minutes, the site will look at the recently created giveaways, and distribute 5% of their total value to everyone. This means creating giveaways is faster and you no longer have that delay. Also, you're almost 100x less likely to run into a few second delay when entering a giveaway. Lastly, the code was improved for transactions surrounding giveaway entries, so there should no longer be deadlocks and endless please wait messages. These changes rolled out a couple of hours ago, and since then you should have seen the button for entering giveaways performing better.
Comment has been collapsed.