Poll
I think the server load has no problem right now, but also that the problem was about the points.
If everytime you create a giveaway the server must calculate how many points everyone should get and distribute them instantly, that may raise the load, as serveral calculations must be done for several giveaways in a short time.
I don't think the number of giveaways in a shord period of time can affect the load right now as the points did!
Comment has been collapsed.
We'll likely run into a few hiccups and performance issues as our new servers are tweaked and configured during the coming days.
Comment has been collapsed.
When you fill out the create giveaway form you're basically just creating a row in a spreadsheet. Sites with dynamic content are almost always driven by databases and store very little static content that's sent to the user as-is (basically only for caching what little static content there is, or cheating a little by doing things like storing the number of entries and adding/subtracting so you don't have to count the number of entries each time someone loads a giveaway page).
On loading a page the server looks up that row on the table (and any necessary related rows from other tables) and populates the page template for you before spitting it back. To the web browser it looks the same as any 'ol static .htm page, but there is no page, it's all in a database.
Comment has been collapsed.
I don't think it'll make a difference either way. The reason the points calculation was changed is because points had to be calculated for thousands of SG users on the fly -- now it's only done every 15 minutes based on the total $$$ value of GAs created in that 15 mins.
By comparison, there aren't anywhere near that many GAs created in a 15 minute span, and relatively few calculations that need to be made per GA created. In fact, moving the GA creation to every 15 minutes may raise the server load, since point calculations are also done that way ...
Comment has been collapsed.
There's still no comparing the relatively small number of giveaways created every 15 minutes to calculating points for over 100,000 SG users every 15 minutes (I don't know the exact numbers, but I know there's well in excess of 100,000 users registered).
Generating pages doesn't take much in the way of resources anyway -- it's just a template that gets filled in with info you provide for the GA and a randomly generated link is created (using whatever algorithm SG uses). Hundreds of people accessing those pages creates a lot more workload for the server than actually creating the page to begin with. Hell, I'd be willing to bet updating these forums constantly is a lot more workload than GA creation.
EDIT: you're not really removing any of the server workload with your suggestion -- you're just making the server do the exact same workload at timed intervals rather than spread out over that 15 mins.
Comment has been collapsed.
Pages don't get created for each user.
Instead, a page has to be generated dynamically for each access - how else would you make sure that you can view the latest comments and modifications?
If you want to reduce the server load, don't F5.
Comment has been collapsed.
Points are refreshed at 15 minute marks? I had no prior knowledge of this.
If giveaways would do the same, it would also save me the effort of refreshing randomly and sometimes missing giveaways that get hidden between others with single minutes apart. And letting people coordinate their refreshes in general.
Comment has been collapsed.
0 Comments - Created 14 minutes ago by Lugum
3 Comments - Last post 16 minutes ago by thoughtfulhippo
21 Comments - Last post 36 minutes ago by BraiNKilleRGR
48 Comments - Last post 1 hour ago by pizzahut
1,761 Comments - Last post 1 hour ago by FranckCastle
22 Comments - Last post 1 hour ago by entomberr
539 Comments - Last post 2 hours ago by Axelflox
1 Comments - Last post 2 minutes ago by Neljer
10 Comments - Last post 3 minutes ago by PoeticKatana
4 Comments - Last post 10 minutes ago by Adelion
91 Comments - Last post 11 minutes ago by AiKirika
174 Comments - Last post 20 minutes ago by galione888
9,140 Comments - Last post 22 minutes ago by fenrir3778
51 Comments - Last post 22 minutes ago by Rzehooj
Just like how the site do the point refresh. The giveaway starts on 0, 15, 30, and 45 minute marks. I hope that it reduce the server load. Do you agree? If no, why?
Comment has been collapsed.