PHP Classes

PHP Tutorials

Recommend this page to a friend!

Articles to teach about PHP matters and related topics

  All package blogs All package blogs   Blog PHP Classes blog   Blog PHP Tutorials   Post article Post article  
  221 - 212   211 - 202   201 - 192   191 - 182   181 - 172   171 - 162   161 - 152   151 - 142   141 - 132   131 - 122   121 - 112   111 - 102   ...   1 - 1  

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-01

Posted on:

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.


Blog More ...   Post a comment Post a comment   See comments 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:

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.


Blog More ...   Post a comment Post a comment   See comments 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:

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.


Blog More ...   Post a comment Post a comment   See comments 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:

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.


Blog More ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)

1113. How to Buy a PHP Elephant Personalized with Your Logo

Updated on: 2022-10-24

Posted on:

The PHP elePHPants are lovely mascots that many PHP developers love for being a symbol of their favorite language. The PHP Classes site sells plush toy versions of the PHP elePHPant.

Today we are announcing a significant improvement to the PHP ElePHPant mascot toys we are making available to make these plush toys even nicer.

From now on, you can purchase a personalized version of the PHP ElePHPant. This fact means that the plush toy may show a logo of your choice on the opposite side of the belly where it shows the PHP logo. Your logo can be an image with your name, your company name, or some other type of image that you can share with us.

Read this article to learn more about these new personalized elePHPants and how you can buy them so you can get them for yourself or for the people that you love the most in your life, hopefully in time for Christmas.


Blog More ...   Post a comment Post a comment   See comments 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:

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.


Blog More ...   Post a comment Post a comment   See comments 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:

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.


Blog More ...   Post a comment Post a comment   See comments See comments (4)   Trackbacks (0)

1110. How to Fix PHP Errors That Affect More Your Applications By Giving Priority to the Most Important Bugs

Updated on: 2022-09-20

Posted on:

Fixing application bugs is a task that often consumes developers a lot of time, especially the step of finding the cause of the bugs. PHP error log processing tools help find the code with bugs causing the errors.

Often developers can find many errors using PHP error log processing methods and tools. If they have many errors, they have another challenge: decide which bugs they should fix first.

One good criterion is first to fix the bugs causing more PHP errors. Counting the PHP errors that appear in a PHP error log may be a task that consumes a lot of time when you do it manually. Fortunately, there are methods and tools that you use to count and sort the PHP errors that appear in PHP logs.

Please read this short article to learn how to use the Scout Application Performance Monitoring tool to quickly determine the lines of code of a PHP application causing more PHP errors so that you can fix those frequent errors first.


Blog More ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)

1109. How to Quickly Find the PHP Errors that Are Preventing Your Application from Working Correctly

Updated on: 2022-09-07

Posted on:

One of the aspects of the developer work that takes us more time is finding and fixing bugs. Sometimes a subtle bug may take us hours to discover the code that is causing the bug and correct the code.

This fact is particularly true when you develop in PHP because the PHP language is very tolerant of programmer mistakes, and subtle bugs do not make the PHP scripts stop working.

Fortunately, there are methods and tools that you use to detect those bugs faster when you can capture the PHP error messages the mistakes may cause.

Please read this short article to learn how to use the Scout Application Performance Monitoring tool to quickly determine the lines of code of a Laravel or Symfony application causing the application to trigger PHP errors that can help you locate the code that you need to fix.


Blog More ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)

1108. How to Discover The Reasons Why Your Application Slowest Parts Are So Slow

Updated on: 2022-08-24

Posted on:

When you discover what parts of your applications are the slowest, you are in an excellent position to start making changes in your code that can significantly impact the application's performance.

Still, you need to understand why that code is so slow, so you can make the right changes to make the code run much faster. This article has some example code to show how to do it manually.

Going through a large section of code and finding the exact lines of slow code can take too much time.

A good profiling tool can help you find the exact lines of code that make the code so slow, so you can quickly determine why the code section is so slow.

Please read this short article to learn how to use the Scout Application Performance Monitoring tool to determine the specific lines of code of a Laravel or Symfony application that are causing the application to be so slow, so you can focus your optimization work on the code changes that really can make a difference after you optimize the code.


Blog More ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)

  221 - 212   211 - 202   201 - 192   191 - 182   181 - 172   171 - 162   161 - 152   151 - 142   141 - 132   131 - 122   121 - 112   111 - 102   ...   1 - 1  
  All package blogs All package blogs   Blog PHP Classes blog   Blog PHP Tutorials   Post article Post article