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?

9 years ago*

Comment has been collapsed.

Poll

View Results
Yes
No
Potato

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!

9 years ago
Permalink

Comment has been collapsed.

They still have to generate pages for everyone now.

9 years ago
Permalink

Comment has been collapsed.

Yeah, but I don't know if that's a great deal, and definitely don't really know enough about the subject, that's just an opinion. xD

I totally find the idea useful should the server load increase anymore, but not right now!

9 years ago
Permalink

Comment has been collapsed.

I think it's only a small difference to us. The server is still unstable sometimes.

9 years ago
Permalink

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.

9 years ago
Permalink

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.

9 years ago
Permalink

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 ...

9 years ago
Permalink

Comment has been collapsed.

They have to generate pages for EVERYONE, but with this, they only have to generate them every 15 mins when users request.

9 years ago
Permalink

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.

9 years ago*
Permalink

Comment has been collapsed.

I think that 1 giveaway = 1 point. Not related to the total value of giveaways.

9 years ago
Permalink

Comment has been collapsed.

You may be correct about that, but those points still have to be calculated and distributed to 1000's of users.

9 years ago
Permalink

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.

9 years ago
Permalink

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.

9 years ago
Permalink

Comment has been collapsed.

Thanks for opinions.

9 years ago
Permalink

Comment has been collapsed.

Closed 8 years ago by coldcocoa.