PHP Classes

Non Obvious MySQL Index Optimization Tricks part 1

Recommend this page to a friend!
  Blog PHP Classes blog   RSS 1.0 feed RSS 2.0 feed   Blog Non Obvious MySQL Ind...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)  

Author:

Viewers: 2,194

Last month viewers: 5

Categories: PHP Tutorials, Lately in PHP Podcast

Every developer knows that adding indexes to database tables may speedup database queries. However, in several circumstances, this may not be the case, and your application may actually get slower when you add indexes.

Watch this short video that is the first part of a talk that teaches what are indexes under the hood, how to determine when you should add indexes to your database tables, when you should not add indexes, and
alternative solutions to optimize MySQL based applications without adding indexes that could slow down your application.




Loaded Article

Introduction

All developers know, or at least should know, that adding indexes to tables may make queries execute faster. They also should know that in some cases adding indexes may also make the application queries run slower.

So it happens that less experienced developers add table indexes when they shouldn't, as well others do not add indexes when they should.

The video below gives you more detailed criteria for you to determine when you should add and indexes or not.

In the second part it covers a more difficult case which is when you need to speedup a database application but you cannot add indexes because those would make the application slower.

For this case, several solutions are presented that can help you to optimize your MySQL database application without needing to add indexes.

At the time of this writing the second part of the talk video is being edited, so if you want to be notified when it is available, signup below the video using your Facebook account (faster notifications) or using your email, so you get a notice when it is up.

New Community for Performance Optimization of PHP, MySQL and JavaScript applications

This short video talk is the first of an initiative to spread the knowledge of experts that understand about performance optimization of applications that use PHP and related technologies.

In the mid-term the idea is to gather experts that can provide support and produce the content of tutorials and slides of the talk presentations and be paid for their contributions, so they feel encouraged to spend more time sharing their knowledge with less experienced developers.

If you want to join this Performance Optimization community, also signup below the video with your Facebook account or by email, so you are notified about new video talks and the get the next steps for those experts that want to contribute in the future.

Video of the Talk "Non Obvious MySQL Index Optimization Tricks: part 1"




You need to be a registered user or login to post a comment

1,611,040 PHP developers registered to the PHP Classes site.
Be One of Us!

Login Immediately with your account on:



Comments:

No comments were submitted yet.



  Blog PHP Classes blog   RSS 1.0 feed RSS 2.0 feed   Blog Non Obvious MySQL Ind...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)