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.
Database choice
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...
Continue further
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.
Buy this course
Before buying this article, you have to buy the previous one
This article is licensed: Premium, by buying this article, you agree with the terms of use.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
Article description
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 credits 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.
David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.