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.
1 Comments - Last post 16 minutes ago by EvilAaron
18 Comments - Last post 25 minutes ago by EvilAaron
159 Comments - Last post 1 hour ago by MeguminShiro
11 Comments - Last post 3 hours ago by Dunther
15 Comments - Last post 3 hours ago by UltimateArck
3 Comments - Last post 4 hours ago by Lugum
10 Comments - Last post 4 hours ago by DeliberateTaco
131 Comments - Last post 5 minutes ago by Eiion
408 Comments - Last post 53 minutes ago by Griske14
26 Comments - Last post 1 hour ago by NeptuneZero
8,622 Comments - Last post 1 hour ago by steveywonder75
35 Comments - Last post 3 hours ago by Grogglz
1,566 Comments - Last post 3 hours ago by ExcelElmira
16,370 Comments - Last post 3 hours ago by MaxiBoi1357
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.