1171. October PHP Events, Customize PHP Composer Hooks, Make WordPress Host a Podcast - 3 minutes - Lately in PHP 96
Updated on: 2023-09-21
Posted on: 2023-09-21
On the Lately in PHP 96 podcast you will learn in 3 minutes about October PHP Events, Customize PHP Composer Hooks, Make WordPress Host a Podcast.
Read this article, watch a 3-minute video, or listen to episode 96 audio of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 10 through September 16.
More ... 
Post a comment 
See comments (0) Trackbacks (0)
Read this article, watch a 3-minute video, or listen to episode 96 audio of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 10 through September 16.
More ... Post a comment See comments (0) Trackbacks (0)1167. Future of PDO, PHP Classes Ideas, Scan Documents into PDF, Tools for Code Quality - 3 minutes - Lately in PHP 95
Updated on: 2023-09-12
Posted on: 2023-09-12
The Lately in PHP podcast is back with a new format that is more direct to the point, thanks to the feedback from our audience.
Read this article, watch a 3-minute video, or listen to episode 95 of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 3 through September 9.
More ... Post a comment See comments (0) Trackbacks (0)
Read this article, watch a 3-minute video, or listen to episode 95 of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 3 through September 9.
More ... Post a comment See comments (0) Trackbacks (0)1146. How to Implement PHP Asyncronous programming using PHP 8.1 Fibers - 6 minutes - Lately in PHP podcast episode 94
Updated on: 2023-03-17
Posted on: 2023-03-17
PHP 8.1 introduced a new feature called fibers, allowing developers to implement PHP asynchronous programming.
If you implement asynchronous programming, it is possible to make your PHP scripts execute multiple tasks in parallel, thus making those scripts faster.
Read this article, watch a 6-minute video, or listen to episode 94 of the Lately in PHP podcast to learn how to use PHP fibers, PHP Swoole, or ReactPHP to make your PHP scripts finish faster.
More ... Post a comment See comments (0) Trackbacks (0)
If you implement asynchronous programming, it is possible to make your PHP scripts execute multiple tasks in parallel, thus making those scripts faster.
Read this article, watch a 6-minute video, or listen to episode 94 of the Lately in PHP podcast to learn how to use PHP fibers, PHP Swoole, or ReactPHP to make your PHP scripts finish faster.
More ... Post a comment See comments (0) Trackbacks (0)1118. How to Verify If the EverSQL MySQL Tool Provides Good Optimization Suggestions - 8 minutes - Lately in PHP Podcast Episode 93 Part 7
Updated on: 2023-03-17
Posted on: 2022-12-21
The EverSQL MySQL optimization tool is excellent for suggesting alterations to MySQL tables and indexes to make SQL queries run faster.
The actual gains in performance may vary depending on the type of query. Significant SQL query optimizations reduce the number of table rows scanned when the MySQL server executes a query.
Read this article, watch an 8-minute video, or listen to part 7 of episode 93 of the Lately in PHP podcast to learn how to verify the efficiency of the MySQL query optimizations suggested by the EverSQL tool.
More ... Post a comment See comments (0) Trackbacks (0)
The actual gains in performance may vary depending on the type of query. Significant SQL query optimizations reduce the number of table rows scanned when the MySQL server executes a query.
Read this article, watch an 8-minute video, or listen to part 7 of episode 93 of the Lately in PHP podcast to learn how to verify the efficiency of the MySQL query optimizations suggested by the EverSQL tool.
More ... Post a comment See comments (0) Trackbacks (0)1117. Make SQL Queries Run Faster Using the EverSQL MySQL Query Optimization Tool - 4 minutes - Lately in PHP Podcast Episode 93 Part 6
Updated on: 2022-12-21
Posted on: 2022-11-30
Slow SQL queries are one of the factors that can make sites slower and cause harm to the user experience.
Fortunately, optimization tools can suggest small changes in your database schema that can make your SQL queries run much, so your Web sites can provide a much better user experience.
EverSQL is one of those optimization tools that can suggest effective changes for databases stored in MySQL servers or some other server compatible with MySQL, such as MariaDB.
Read this article, watch a 4-minute video, or listen to part 6 of episode 93 of the Lately in PHP podcast to learn how to optimize your MySQL database using the EverSQL tool for free.
More ... Post a comment See comments (0) Trackbacks (0)
Fortunately, optimization tools can suggest small changes in your database schema that can make your SQL queries run much, so your Web sites can provide a much better user experience.
EverSQL is one of those optimization tools that can suggest effective changes for databases stored in MySQL servers or some other server compatible with MySQL, such as MariaDB.
Read this article, watch a 4-minute video, or listen to part 6 of episode 93 of the Lately in PHP podcast to learn how to optimize your MySQL database using the EverSQL tool for free.
More ... Post a comment See comments (0) Trackbacks (0)1116. How to Help the EverSQL Tool Optimizing MySQL SQL Queries More Efficiently by Passing It Your MySQL Database Metadata - 4 minutes - Lately in PHP Podcast Episode 93 Part 5
Updated on: 2022-11-30
Posted on: 2022-11-17
The EverSQL tool is excellent for suggesting optimizations for SQL queries for your applications that use MySQL.
That tool must first obtain the structure of your database tables to suggest good optimizations. You can get that structure by executing a SQL query that extracts the database metadata.
Read this article, watch a 4-minute video, or listen to part 4 of episode 93 of the Lately in PHP podcast to learn how to extract your MySQL database metadata to help the EverSQL tool to optimize your application SQL queries for free.
More ... Post a comment See comments (2) Trackbacks (0)
That tool must first obtain the structure of your database tables to suggest good optimizations. You can get that structure by executing a SQL query that extracts the database metadata.
Read this article, watch a 4-minute video, or listen to part 4 of episode 93 of the Lately in PHP podcast to learn how to extract your MySQL database metadata to help the EverSQL tool to optimize your application SQL queries for free.
More ... Post a comment See comments (2) Trackbacks (0)1115. Introduction on How to Use the EverSQL MySQL Query Optimizer Tool for Free - 3 minutes - Lately in PHP Podcast Episode 93 Part 4
Updated on: 2022-11-17
Posted on: 2022-11-08
When you want to optimize SQL queries to optimize an application that uses MySQL, you can use "manual" methods. These methods require good SQL query optimization knowledge. If you need to optimize many SQL queries, doing it "manually" may also take time.
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.
More ... Post a comment See comments (0) Trackbacks (0)
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.
More ... Post a comment See comments (0) Trackbacks (0)1114. How to Use Simple MySQL Monitoring Tools for Free to Find the Slowest Queries that You Should Optimize First - 2 minutes - Lately in PHP Podcast Episode 93 Part 3
Updated on: 2022-10-25
Posted on: 2022-10-25
When you want to optimize the performance of a MySQL-based application, you should try to optimize first the slowest queries that affect the application's performance.
The MySQL slow query log file provides a list of slow queries as they happen. So you need to monitor that file to determine the most critical slow SQL queries you need to optimize first.
Read this article, watch a 2-minute video, or listen to part 3 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to monitor the MySQL slow query log and find the slowest SQL queries.
More ... Post a comment See comments (0) Trackbacks (0)
The MySQL slow query log file provides a list of slow queries as they happen. So you need to monitor that file to determine the most critical slow SQL queries you need to optimize first.
Read this article, watch a 2-minute video, or listen to part 3 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to monitor the MySQL slow query log and find the slowest SQL queries.
More ... Post a comment See comments (0) Trackbacks (0)1112. How to Find MySQL Slow Queries in a Production Server by Activating the Slow Query Log - 2 minutes - Lately in PHP Podcast Episode 93 Part 2
Updated on: 2022-10-19
Posted on: 2022-10-19
When you want to optimize a MySQL database application in production, you should figure out the slowest queries in that environment.
Enabling the MySQL slow query log can help you figure out the slowest SQL queries to optimize first. You can do that in a production environment, but you need to take extra care with how you enable the slow query log to avoid causing harm to the application.
Read this article, watch a 2-minute video, or listen to part 2 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log in a production environment in a safe way.
More ... Post a comment See comments (0) Trackbacks (0)
Enabling the MySQL slow query log can help you figure out the slowest SQL queries to optimize first. You can do that in a production environment, but you need to take extra care with how you enable the slow query log to avoid causing harm to the application.
Read this article, watch a 2-minute video, or listen to part 2 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log in a production environment in a safe way.
More ... Post a comment See comments (0) Trackbacks (0)1111. Find MySQL Slow Queries by Activating the Slow Query Log - 7 minutes - Lately in PHP Podcast Episode 93 Part 1
Updated on: 2022-10-13
Posted on: 2022-10-13
One of the factors that may make a Web application slow is the speed of execution of database queries executed by the application back-end code.
If you optimize the database queries that are the slowest, it may make a lot of impact on the speed of an application.
The first step in optimizing the slowest database queries is to find which are the slowest queries. Using MySQL as the database server, you can find the slowest queries by activating the slow query log.
Read this article, watch a 7-minute video, or listen to part 1 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log.
More ... Post a comment See comments (4) Trackbacks (0)
If you optimize the database queries that are the slowest, it may make a lot of impact on the speed of an application.
The first step in optimizing the slowest database queries is to find which are the slowest queries. Using MySQL as the database server, you can find the slowest queries by activating the slow query log.
Read this article, watch a 7-minute video, or listen to part 1 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log.
More ... Post a comment See comments (4) Trackbacks (0)
