README

Blazing-fast query optimization for Laravel

✅ Supported Versions

• Laravel: 8.x, 9.x, 10.x
• PHP: 7.4+, 8.0+

🚀 Features

• ⚡ Automatic query optimization
• 💾 Intelligent memory management
• 📈 Performance monitoring
• 🔄 Smart caching system
• 📊 Detailed analytics
• 🧠 Memory-safe chunking for large datasets
• 🔍 Eager loading optimization with N+1 detection
• 🧮 Query explanation & index recommendations
• 🛡️ Memory profiling to prevent leaks

🚀 Basic Usage-

Query Optimization

composer require varunazad/laravel-quicksilver

use Varunazad\Quicksilver\Facades\Quicksilver;


$optimizedUsers = Quicksilver::optimizeQuery(
    User::where('active', true)
)->get();

Query Optimization

$optimizedUsers = Quicksilver::optimizeQuery(
    User::where('active', true)
)->get();

Memory Management

    Quicksilver::startMemoryOptimization();

    // Your memory-intensive operations here
    processLargeDataset();

    Quicksilver::stopMemoryOptimization();

Caching

$posts = Quicksilver::cacheQuery(
    Post::with('comments')->popular(),
    'popular_posts',
    60 // Cache for 60 minutes
);

Configuration

After publishing the config file (config/quicksilver.php), you can customize:

return [
    'query_optimization' => true,
    'memory_management' => true,
    'cache_enabled' => true,
    'monitor_performance' => env('QUICKSILVER_MONITOR', false),
];


    Quicksilver::startMemoryOptimization();

    // Your memory-intensive operations here
    processLargeDataset();

    Quicksilver::stopMemoryOptimization();
Caching


$posts = Quicksilver::cacheQuery(
    Post::with('comments')->popular(),
    'popular_posts',
    60 // Cache for 60 minutes
);

Configuration

After publishing the config file (config/quicksilver.php), you can customize:

return [
    'query_optimization' => true,
    'memory_management' => true,
    'cache_enabled' => true,
    'monitor_performance' => env('QUICKSILVER_MONITOR', false),
];

📦 Installation

composer require varunazad/laravel-quicksilver
---