Lesson 12 - MySQL Step by Step: Database Performance Optimization
In the previous lesson, MySQL Step By Step: Structure Change, Transactions and Views, we showed how to change the database structure, transactions, and views. Today, we're going to focus on optimizing the database performance. It depends on many factors and can be scaled very easily.
The first factor, of course, is the database we choose. MySQL isn't the best in performance, but when set up properly, it should be enough for most projects. More powerful databases would be, for example, SQLite or PostgreSQL. In the corporate sector,
...End of the preview...
You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
Requested article covers this content:
In this tutorial, we'll learn how to optimize/increase performance of the MySQL database by indexes/keys and talk about normalization and denormalization.
You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.