From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 2 Design and Deployment

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Designing for performance

Designing for performance

- When it comes to designing or planning for performance, there are a few considerations that you need to make. And one of the big ones is really just the design of the actual instance that your database management system is going to run on. Whether you're doing an EC2 instance, or you're letting AWS RDS create the instance for you, you still have parameters that are going to impact the performance of that instance. So what are the requirements for good performance? First of all, the first and ultimate requirement for particularly relational database systems is that memory is used more than discs. You want to have the stuff in memory that you need more often than not. Now, let me kind of walk you through this concept. If you have a database system, where the same people are doing the same kind of work against that database, odds are, they're going to need some of the same data. And if that data is retained in memory,…

Contents