Performance and Scalability


This chapter is about performance measurements and scalability of databases.

In this context, I am using the following definition for scalability:

Scalability is the ability of a system, network, or process,
to handle growing amount of work in a capable manner
or
its ability to be enlarged to accommodate that growth.

You see that there are actually two definitions. The first one is about the effects of growing load on a system. The second one is about growing the system to handle more load.

The second definition enjoys great popularity. Whenever somebody talks about scalability, it is almost always about using more hardware. Scale-Up and Scale-Out are the respective keywords, which were complemented by new buzzwords like Web-Scale recently.

It's a book!
You are just reading a book. Here is the table of content

Scalability is, in general, about the performance trend caused environmental changes. Hardware is just one environmental variable that may change. This chapter covers other variables like data volume and system load as well.

Recent Questions at Ask.Use-The-Index-Luke.com

0
votes
1
answer
229
views

query regd the CBO decision

Apr 17 at 10:27 Hulda(suspended)
index-choice optimizer
0
votes
3
answers
2.0k
views

Examples for Function Based Indexes?

Mar 25 at 15:52 Castorp 1
function-based
0
votes
1
answer
610
views

Updating multiple rows using a subquery in SQL

Jan 08 at 09:52 Jan 26
subquery update sql