Lots of neat updates lately. Thanks for your work, cg!
Comment has been collapsed.
But now you can't spam refresh hoping for that last point you need to enter a giveaway ending in 3 minutes.
Comment has been collapsed.
508 Comments - Last post 13 minutes ago by Gyhulhu
70 Comments - Last post 1 hour ago by herbesdeprovence
323 Comments - Last post 2 hours ago by Acojonancio
31 Comments - Last post 3 hours ago by Skwerm
37 Comments - Last post 6 hours ago by Liandri
202 Comments - Last post 10 hours ago by Dawnslayer
156 Comments - Last post 18 hours ago by marilynhanson
32 Comments - Last post 1 minute ago by zeus9860
23 Comments - Last post 3 minutes ago by MBcoder
8,043 Comments - Last post 4 minutes ago by Carenard
5,811 Comments - Last post 4 minutes ago by vigaristti
50 Comments - Last post 6 minutes ago by dantenemo
72 Comments - Last post 13 minutes ago by duville
19 Comments - Last post 15 minutes ago by Raggart
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.