Benchmark Artisan Commands

(Part of the video Import One Million Rows To The Database (PHP/Laravel))

#Artisan Benchmark

#Installation

composer require christophrumpel/artisan-benchmark

#Usage

This package lets you benchmark your artisan commands:

php artisan benchmark your:command

Simply replace ⁠your:command with your command signature. After execution, you'll see detailed benchmark results.

If you run the command without a signature, it will display a list of available commands to choose from:

php artisan benchmark

#Table Count Monitoring

You can monitor changes in a specific database table's record count by using the ⁠--tableToWatch option:

php artisan benchmark your:command --tableToWatch=users

Be aware that it only shows the count difference from before running your command.

#Technical Details

#Query Count

The package uses Laravel's query logging functionality to track the number of database queries:

DB::enableQueryLog();
DB::flushQueryLog();

Please note that this only tracks queries executed through Eloquent or the Query Builder. Direct database queries will not be counted. Contributions for improving this functionality are welcome.