Today's Totals
-
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. :thumbsup: 869,415 Workspaces 10,630,082 Members 3,068,212,852 Article views
.'\\ /\`. .'.-.\`-'.-.\`. ...\_: .-. .-. :\_... .' '-.(o ) (o ).-' \`. : \_ \_ \_\`~(\_)~\`\_ \_ \_ : : /: ' .-=\_ \_=-. \` ;\\ : : :|-..\_ ' \` \_..-|: : : \`:| |\`:-:-.-:-:'| |:' : \`. \`.| | | | | | |.' .' \`. \`-:\_| | |\_:-' .' \`-.\_ \`\`\`\` \_.-' \`\`-------'/xml> -
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. :thumbsup: 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)[^]
-
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)[^]
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. ;P
.'\\ /\`. .'.-.\`-'.-.\`. ...\_: .-. .-. :\_... .' '-.(o ) (o ).-' \`. : \_ \_ \_\`~(\_)~\`\_ \_ \_ : : /: ' .-=\_ \_=-. \` ;\\ : : :|-..\_ ' \` \_..-|: : : \`:| |\`:-:-.-:-:'| |:' : \`. \`.| | | | | | |.' .' \`. \`-:\_| | |\_:-' .' \`-.\_ \`\`\`\` \_.-' \`\`-------'/xml> -
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. ;P
.'\\ /\`. .'.-.\`-'.-.\`. ...\_: .-. .-. :\_... .' '-.(o ) (o ).-' \`. : \_ \_ \_\`~(\_)~\`\_ \_ \_ : : /: ' .-=\_ \_=-. \` ;\\ : : :|-..\_ ' \` \_..-|: : : \`:| |\`:-:-.-:-:'| |:' : \`. \`.| | | | | | |.' .' \`. \`-:\_| | |\_:-' .' \`-.\_ \`\`\`\` \_.-' \`\`-------'/xml>M@dHatter wrote:
if not designed properly
Ah so secretly you are questioning the capabilities of the team? :-D
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. :laugh: it is just pretend that they are using all these fancy databases and cloud technologies.:~
-
M@dHatter wrote:
if not designed properly
Ah so secretly you are questioning the capabilities of the team? :-D
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. :laugh: 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 – ∞)
-
M@dHatter wrote:
if not designed properly
Ah so secretly you are questioning the capabilities of the team? :-D
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. :laugh: it is just pretend that they are using all these fancy databases and cloud technologies.:~
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.
