Laravel Slower

Enhance the performance of your Laravel applications by identifying and optimizing slow database queries with Laravel Slower.

Introduction

Laravel Slower is designed to help developers identify slow database queries and provides AI-powered recommendations to optimize these queries. The package can be integrated seamlessly into any Laravel project and offers configurable options for both manual and automated performance tuning.

Installation

Step 1: Composer Installation

To install the package via Composer, run the following command in your terminal:

composer require halilcosdu/laravel-slower

Step 2: Publish Configuration

After installation, you need to publish the configuration file to set up your preferences:

php artisan vendor:publish --tag="slower-config"

Configuration

The config/slower.php file allows you to customize various aspects of the package:

enabled: Enable or disable logging of slow queries.
threshold: Define the execution time threshold (in milliseconds) that determines what constitutes a slow query.
ai_recommendation: Toggle AI-based optimization recommendations.

Usage

Integrate Laravel Slower into your application to monitor and optimize database performance.

Monitoring Queries

To start monitoring your database queries, add the following commands to your console kernel:

php artisan slower:analyze

This command analyzes the queries that exceed the defined slow query threshold and logs them for review.

Optimizing Queries

If AI recommendations are enabled, the package will suggest optimizations based on the analysis of slow queries. You can view these recommendations in the database logs or through the application's log viewer.

Troubleshooting

If you encounter issues with Laravel Slower, consider the following troubleshooting steps:

Check the Laravel log for any error messages related to the package.
Ensure that the database connection settings are correct and that your database server is accessible.
Verify that your environment variables are set correctly for the package to function.
Make sure the AI recommendations are not disabled if you are expecting optimization suggestions.

Additional Resources

For more detailed usage examples, configuration settings, and community contributions, please visit the Laravel Slower GitHub repository:

Visit GitHub Repository

Support and Contributions

Your contributions to improving Laravel Slower are welcome. Please refer to the contributing guidelines on our GitHub repository to get started.