|
With those kind of totals, Chris and the team are probably running into database constraints. Good job keeping the site running all these years. It's been fast and reliable. 
869,415
Workspaces
10,630,082
Members
3,068,212,852
Article views
.'\ /`.
.'.-.`-'.-.`.
..._: .-. .-. :_...
.' '-.(o ) (o ).-' `.
: _ _ _`~(_)~`_ _ _ :
: /: ' .-=_ _=-. ` ;\ :
: :|-.._ ' ` _..-|: :
: `:| |`:-:-.-:-:'| |:' :
`. `.| | | | | | |.' .'
`. `-:_| | |_:-' .'
`-._ ```` _.-'
``-------'/xml>
|
|
|
|
|
M@dHatter wrote: running into database constraints
Why?
These are small numbers in database terms. When you think that they are utilising Amazon Cloud Services (for ::Workspaces). Just look at the recent Azure numbers, 20 Trillion Objects, 1 million SQL databases, 2 million requests per second etc. etc. (souce)[^]
modified 25-May-14 12:07pm.
|
|
|
|
|
Actually 1 mil objects in anything accessed repeatedly can be a lot.
i.e 1,000,000 rows X 20 user requests a sec.
As of databases though 10,000,000 rows can be an issue if not designed properly. Comparing enterprise cloud services to inhouse databases are completely different.
If I had a billion dollar budget, I could spread out workload too. So what is your point? A couple of years ago Chris had it all in one table. 
.'\ /`.
.'.-.`-'.-.`.
..._: .-. .-. :_...
.' '-.(o ) (o ).-' `.
: _ _ _`~(_)~`_ _ _ :
: /: ' .-=_ _=-. ` ;\ :
: :|-.._ ' ` _..-|: :
: `:| |`:-:-.-:-:'| |:' :
`. `.| | | | | | |.' .'
`. `-:_| | |_:-' .'
`-._ ```` _.-'
``-------'/xml>
|
|
|
|
|
M@dHatter wrote: if not designed properly
Ah so secretly you are questioning the capabilities of the team? 
M@dHatter wrote: Comparing enterprise cloud services to inhouse databases
Move data inhouse, reduced latency, but probably slower disk times. Move data to the cloud, higher latency, but probably faster disk times. Implementation in either scenario is everything.
M@dHatter wrote: A couple of years ago Chris had it all in one table
I think he still does, he hasn't worked out how to do SQL joins yet or LINQ includes.  it is just pretend that they are using all these fancy databases and cloud technologies.
|
|
|
|
|
I think it's all still running on a network of psion handhelds, isn't it?
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
DaveAuld wrote: he hasn't worked out how to do SQL joins yet or LINQ includes.
Ya, he keeps asking in QA over and over even though we keep telling him how. 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
OK Carlo, close your eyes and vote the right clown.
Veni, vidi, vici.
|
|
|
|
|
Did you just bring politics into the lounge?
Oops, I confused politics with an ineffective money devouring machine that somehow makes all the wrong decisions.
Or are those interchangeable?
It's an OO world.
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
Sander Rossel wrote: an ineffective money devouring machine that somehow makes all the wrong decisions.
No...it's a very effective money devouring machine that somehow makes all the wrong decisions.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Not what I meant, but yeah... You're right
An ineffective, money devouring machine...
I think the comma does it.
It's an OO world.
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
Well, you know, the decisions are always wrong for someone.
But usually for most people except for those cashing in.
|
|
|
|
|
Sander Rossel wrote: Did you just bring politics farce into the lounge?
Yes, deliberately.
Veni, vidi, vici.
|
|
|
|
|
You should've used the joke icon 
It's an OO world.
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
You know, I don't understimate...
Veni, vidi, vici.
|
|
|
|
|
He did: he titled it "European elections"...
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Sander Rossel wrote: money devouring machine
Indeed[^]
|
|
|
|
|
Had I seen that before the voting I would've voted Wilders
Away with the Euro parliament!
It's an OO world.
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
|
Paging Brian Blessed[^]!
Brian Blessed to the microphone, please.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
CPallini wrote: OK Carlo, close your eyes hold your nose and vote the right clown.
FTFY
Along with Antimatter and Dark Matter they've discovered the existence of Doesn't Matter which appears to have no effect on the universe whatsoever!
Rich Tennant 5th Wave
|
|
|
|
|
CPallini wrote: vote the right clown
That is insulting to clowns everywhere
|
|
|
|
|
Exactly!
Veni, vidi, vici.
|
|
|
|
|
Vote right + elections = impossible
Choosing between bad and bad is still bad.
Anyway at least you didn't have to waste 8 hours sitting there in forced labor for (almost) no pay.
Pff never again, next time I'll just pay the freaking fine.
|
|
|
|
|
Tom Deketelaere wrote: nyway at least you didn't have to waste 8 hours sitting there in forced labor for (almost) no pay.
Pff never again, next time I'll just pay the freaking fine.
So you won a 'socially useful' job, like our former PM Silvio? Congratulations!
Veni, vidi, vici.
|
|
|
|
|
CPallini wrote: socially useful'
Don't know about that, the temptation to start laughing with people's names got bigger and bigger as the hours passed (damn there are some really weird names out there)
I did the math, normally what they payed me would be enough for 20min of work but since it's on a sunday and those are usually double pay ...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
