Performance testing in GraphQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is performance testing in databases?

Performance testing checks how fast and efficiently a database handles queries and operations under different conditions.

beginner

Name one common metric measured during database performance testing.

Response time, which is how long it takes for the database to return results after a query is sent.

intermediate

Why is load testing important in database performance testing?

Load testing simulates many users or queries at once to see if the database can handle high traffic without slowing down or crashing.

intermediate

What is a bottleneck in database performance?

A bottleneck is a part of the database system that slows down overall performance, like slow queries or limited hardware resources.

beginner

How can indexing improve database performance?

Indexing creates a quick lookup for data, reducing the time needed to find and retrieve information during queries.

What does response time measure in database performance testing?

A Time taken to return query results

B Number of users connected

C Amount of data stored

D Frequency of backups

Response time is the duration from sending a query to receiving the results.

Which test simulates many users querying the database at once?

A Unit testing

B Load testing

C Integration testing

D Security testing

Load testing checks how the database performs under heavy user or query load.

What is a common cause of a performance bottleneck in databases?

A Fast network connection

B Efficient indexing

C Slow queries

D High disk space

Slow queries can delay the whole system, causing a bottleneck.

How does indexing affect query speed?

A Slows down queries

B Has no effect

C Deletes data

D Speeds up queries

Indexing helps the database find data faster, improving query speed.

Which metric is NOT typically measured in database performance testing?

A Query accuracy

B Response time

C Throughput

D Resource usage

Query accuracy is about correctness, not performance.

Explain what performance testing is and why it matters for databases.

Think about how fast and well a database works under pressure.

Describe how indexing can improve database performance and what problem it solves.

Imagine a book’s index helping you find pages quickly.