You are viewing a single comment's thread.

view the rest of the comments →

Le_Squish ago

Putt, have you considered daily downtown to cut cost in a more immediate way? 2 or 3 hours everyday during slow posting times?

Edit: Some goats are suggesting going down on Sundays...what you think? Off day for you at least based admin.

Crensch ago

I'd even be OK with cycling on and off every half hour. As those faggot T_D said, our front page is slow. News is slow. We can get our fix for a half our, and come back a half hour later to do it again.

It'd be novel idea, but would double the time we can stay afloat if it's viable.

GasRite ago

EE with practically no hosting knowledge here:

Can you run a website with something similar to time-delay multiplexing? Like, have it be "offline" and display a static cached copy for 29.9 minutes while keeping a log of all comments/submissions/votes that are sent in during that time and then at t=30min, "go live" for a second to update all the comments and vote tallies?

That way the site doesn't incur the cost of remaining live all the time, but its still always browse-able. Just with a little bit of a lag time between actions. You could even stagger the update times or scale them based on traffic or other factors.

Is that something that would work?

kyle ago

The server would still have to be running all the time, the only difference would be that it's serving up static pages instead of dynamic ones. It would reduce the number of database queries, sure, but I don't think that would make a huge difference. Plus, the end-user experience would be hit hard, and it would require a massive overhaul of the site's code.

superdisk ago

What really needs to be fixed is the database queries, the site fetches the comments in an N+1 query and hits the database hundreds of times on each request.

kyle ago

Is this true? How would you know that this is the issue? (serious question, not being snarky)

superdisk ago

You can go look at the ugly LINQ queries on github, this site is open source.