Author: Manuel Lemos
Viewers: 321
Last month viewers: 4
Categories: PHP Tutorials, Lately in PHP Podcast
One way to optimize SQL queries without requiring you to learn so much about optimization is to use a SQL query optimization tool. Optimization tools also take you much less time to optimize many queries than if you try manually.
Read this article, watch a 3-minute video, or listen to part 4 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to optimize MySQL SQL queries without much knowledge and faster than if you try to do it manually.
In this article you can learn:
How to Improve the Speed of An Application that Uses a MySQL Database Server
1. Previous Article: Find MySQL Slow Queries by Activating the Slow Query Log
2. Previous Article: Find MySQL Slow Queries in a Production Server by Activating the Slow Query Log
3. Previous Article: How to Use Simple MySQL Monitoring Tools for Free to Find the Slowest Queries that You Should Optimize First
4. This Article: Introduction on How to Use EverSQL SQL Query Optimizer Tool to Optimize Specific SQL Queries
5. Next Article: How to Help the EverSQL Tool Optimizing MySQL SQL Queries More Efficiently by Passing It Your MySQL Database Metadata
Contents
Listen or download the podcast, RSS feed and subscribe in iTunes
Watch the podcast video, subscribe to the podcast YouTube channel
What was said in the podcast
Show notes
Listen or download the podcast, RSS feed and subscribe in iTunes
Introduction music obtained with permission from: http://spoti.fi/NCS
Sound effects obtained with permission from: https://www.zapsplat.com/
In iTunes, use the Subscribe to Podcast... item of the Advanced menu, and then enter the URL above to subscribe to this podcast.
Watch the podcast video
See the Lately in PHP podcast play list on YouTube and Subscribe to this channel there.
Episode 93 Part 4 Video
What was said in the podcast
Introduction on How to Use EverSQL SQL Query Optimizer Tool to Optimize Specific SQL Queries
In the next step, I'm going to show a tool.
You can also, do it manually by analyzing your database table if you have the knowledge and also the time because when you do something in a manual way you spend a lot of time doing it in a way that it's good.
There's no problem doing it manually except that it may take a lot of time. You may need that time to do other things, and if you have many queries to optimize the time that you spend optimizing will end up being a lot more time than if you have a better way.
So a better way is to use a tool that is specialized in this task, MySQL database optimization. In the case I'm going to show EverSQL. There are other tools for this purpose. I tried this tool. I like it because it works really well. So I'm going to show how it works. It has several functions.
You may see here optimize a single query and also monitor and optimize my database.
We already did the monitoring in, I would say, manual way. So we don't need to use this part now. Maybe in the future episode of the podcast, I can show you.
How can you use this part of the tool but let's focus on the actual SQL query optimization.
Show notes
You need to be a registered user or login to post a comment
1,616,398 PHP developers registered to the PHP Classes site.
Be One of Us!
Login Immediately with your account on:
Comments:
No comments were submitted yet.