The scalability tag has no wiki summary.
33
votes
5answers
2k views
Why can't RDBM's cluster the way NoSQL does?
One of the big plusses for nosql DBMS is that they can cluster more easily. Supposedly with NoSQL you can create hundreds of cheap machines that store different pieces of data and query it all at ...
9
votes
3answers
3k views
What does horizontal scaling mean?
In database context, I have come across horizontal scalability as one of the advantages of the NOSQL databases. What does the term mean?
http://en.wikipedia.org/wiki/CouchDB
...
7
votes
3answers
1k views
SQL Server - Multiple running totals
I've got a base table with transactions and I need to create a table with running totals. I need them to be per account and and also have a few running totals for each account (depending on the ...
6
votes
3answers
808 views
Testing stored procedure scalability
I have an email application that will be called upon to deliver to the UI the number of new messages for a given user on each page load. I have a few variations of things I am testing on the DB level ...
5
votes
3answers
1k views
Database suggestion for a social network/ knowledge base community?
I am looking into various database types and DBMS's for a new project I am wanting to start in the summer.
I have built systems in MySQL and postgreSQL , now I am wanting to expand my knowledge and ...
5
votes
3answers
256 views
How to store many smallish time-series in a relational DB?
Input Data
Multiple Tests Beds generate measurement data of various complexity.
In it's most basic form, not considering any meta-data, one measurement on a Test Bed will be a small (1 - a few ...
4
votes
3answers
3k views
Why can't relational databases meet the scales of Big Data?
It is often repeated that the Big Data problem is that relational databases can not scale to process the massive volumes of data that are now being created.
But what are these scalability limitations ...
4
votes
3answers
596 views
MySQL tables/databases into different disks
I am aware that there is a possibility to have a single database server with many tables/databases, and you can separate some of those tables/databases into separate disks.
Lets say you have 5 ...
4
votes
3answers
3k views
How does one scale SQL Server 2008 or 2012?
How does one scale SQL Server 2008 (or 2012)? At its basic, I understand there are two options:
Scale up:
If CPU bound, I can clearly see going from 1 CPU core to 2 to 4. Or if RAM usage rockets, ...
4
votes
2answers
749 views
Are there any in-memory NoSQL databases?
Given that NoSQL databases are designed to support horizontal scalability by throwing in more servers, are there any that are designed to do entirely without persistent disk storage?
I'm looking at ...
3
votes
3answers
186 views
Is it better to seperate a big query into multiple smaller queries?
There are situations which require to have really big query joining several tables together with sub select statements in them to produce the desired results.
My question is, should we consider using ...
3
votes
1answer
174 views
to what “scale” of applications does nosql support?
Recently i came across the Nosql database concept, though i learnt how to and why of it, i did not get a proper answer to the question , to what scale of project does it support?
Will it support ...
3
votes
1answer
198 views
Postgres scalability - What is the impact of connection pooling?
We had a question over on Server Fault that raised an interesting question:
In light of the scalability improvements in Postgres 9.2 scalability improvements, is it better to use connection pooling ...
3
votes
2answers
481 views
Proper storage size estimation technique for PostgreSQL
We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We are a team of developers with low expertise on database administration, so we ...
3
votes
2answers
379 views
Scalable DBaaS that can scale to hundreds of terabytes with easy backup and restore
I've gone over many DBaaS solutions, including Xeround (limited to 50G, in memory), NuoDB (currently in beta 7), DrawnToScale (not out yet), MongoDB (in memory), RavenDB (for ASP.NET, but NoSQL) and ...
