Get up to 80 % extra points for free! More info:

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 will gain knowledge worth hundreds of thousands for a few crowns

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.

Limited offer: Learn all knowledge and save money

Buy all currently available lessons with exercise submitting and other features for an exclusive price $3.87
Current account balance $0
By buying this exclusive package, you'll have access to all 13 lessons in this course including exercise submitting while saving $0.63. This offer is limited for the first lessons only with an additional exclusive 15% discount.

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.

What will you get from us in the next lessons?
  • 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.

Article has been written for you by David Capka
The author is a programmer, who likes web technologies and being the lead/chief article writer at He shares his knowledge with the community and is always looking to improve. He believes that anyone can do what they set their mind to.
Unicorn university David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.