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.
50 Comments - Last post 1 minute ago by OneManArmyStar
1,466 Comments - Last post 54 minutes ago by star4you
498 Comments - Last post 55 minutes ago by WaxWorm
3 Comments - Last post 1 hour ago by ultninjaF
8 Comments - Last post 1 hour ago by WingsOfHope
138 Comments - Last post 1 hour ago by Gamy7
169 Comments - Last post 1 hour ago by rasLivity
10,404 Comments - Last post 7 minutes ago by JMM72
2,426 Comments - Last post 12 minutes ago by JMM72
48 Comments - Last post 13 minutes ago by JMM72
6,786 Comments - Last post 15 minutes ago by knsys
152 Comments - Last post 28 minutes ago by Lucifera
108 Comments - Last post 33 minutes ago by duville
123 Comments - Last post 44 minutes ago by Yorickmeister
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.