Detailed explanation of laravel mysql table optimization

The following tutorial column ofLaravelwill give you a detailed explanation of laravel mysql table optimization. I hope it will be helpful to friends in need!

1. Configuration information cache

Use the following Artisan built-in commands to merge all the configuration information in the config folder into one file to reduce runtime Number of files loaded:

php artisan config:cache

The above command will generate the file bootstrap/cache/config.php. You can use the following command to cancel the configuration information cache:

php artisan config:clear

What this command does is to The bootstrap/cache/config.php file is deleted.

Note: The configuration information cache will not be automatically reloaded with updates. Therefore, it is recommended to turn off the configuration information cache during development. It is generally used in production environments and can be used with the Envoy task runner.

2. Route cache

Route cache can effectively improve the registration efficiency of the router. The effect is more obvious in large applications. You can use the following command:

php artisan route:cache

Above The command will generate the bootstrap/cache/routes.php file. It should be noted that the route cache does not support routing anonymous function writing logic.

You can use the following command to clear the routing cache:

php artisan route:clear

What this command does is delete the bootstrap/cache/routes.php file.

Note: The route cache will not be automatically reloaded with updates. Therefore, it is recommended to turn off the route cache during development. It is generally used in production environments and can be used with the Envoy task runner.

3. Class mapping loading optimization

optimize command merges commonly loaded classes into one file to improve operating efficiency by reducing file loading:

php artisan optimize --force

will generate two files, bootstrap/cache/compiled.php and bootstrap/cache/services.json.

You can add classes to be merged by modifying the config/compile.php file.

In the production environment, the parameter --force does not need to be specified, and the file will be automatically generated.

To clear class map loading optimization, run the following command:

php artisan clear-compiled

This command will delete the two files generated by optimize above.

Note: This command must be run after php artisan config:cache, because the optimize command generates files based on configuration information (such as the providers array of the config/app.php file).

4. Automatic loading optimization

This command is not only for Laravel programs, but also applies to all programs built using composer. This command will convert PSR-0 and PSR-4 into a class mapping table to improve class loading speed.

composer dumpautoload -o

Note: This operation has already been done in the php artisan optimize --force command.

5. Use Memcached to store sessions

Every Laravel request will generate a session. Modifying the session storage method can effectively improve program efficiency. The session configuration information is config/session.php , it is recommended to change it to professional caching software such as Memcached or Redis:

'driver' => 'memcached',

6. Use a professional cache driver

"cache" It is one of the magic weapons to improve the running efficiency of applications. The default cache driver is file cache. It is recommended to switch to a professional cache system, such as Redis or Memcached. It is not recommended to use database cache.

'default' => 'redis',

7. Database request optimization

Use delayed preloading and preloading when reading data association models;

Use Laravel Debugbar or Clockwork to pay attention to the total number of database requests for each page;

The space here is only related to Laravel. For other content about data optimization, please check other information by yourself.

8. Write caching logic for the data set

Properly use the cache layer operation provided by Laravel to cache the data set taken out from the database, reduce the pressure on the database, and run in memory The professional caching software on the Internet can also read data much faster than the database.

$posts = Cache::remember('index.posts', $minutes = 30, function() { return Post::with('comments', 'tags', 'author', 'seo')->whereHidden(0)->get(); });

remember Even the data association model is cached, how convenient it is.

9. Using just-in-time compilers

HHVM and OpCache can easily improve the performance of your application by 50% or more without making any modifications. , PHPhub did an experiment before. For details, please see: Using OpCache to improve PHP 5.5 program performance.

10. Front-end resource merging

As an optimization standard, a page should only load one CSS and one JS file, and the file must be able to easily go to CDN, and the file name needs to change with modification. .

The above is the detailed content of Detailed explanation of laravel mysql table optimization. For more information, please follow other related articles on the PHP Chinese website!