Qisthi Ramadhani Tag: performance
All posts with tag "performance".
-
Beyond Eloquent: Think Like a Database (Laravel + PostgreSQL Performance Part 1)
Eloquent is elegant, but every Laravel developer eventually hits performance walls caused by hidden SQL inefficiencies. This first part explains the mindset shift from imperative PHP to declarative SQL, exposes pitfalls like N+1 and the 'shopping list problem,' and gives a simple first habit: inspect the actual queries your code generates.
-
Navigating Common SQL Performance Traps: !=, NULL, LIKE, and GROUP BY
Dive into common but tricky SQL query patterns that silently kill performance. Learn how to optimize !=, IS NULL, LIKE, and GROUP BY clauses with the right indexing strategies for faster, more efficient applications.
-
Unlocking Performance: A Pragmatic Guide to Laravel Database Indexing
Struggling with slow Eloquent queries? Database indexing doesn't have to be a black box. This guide translates deep database principles into practical, everyday Laravel techniques. Learn to craft efficient single and multi-column indexes with migrations, optimize your `where` and `orderBy` clauses, and debug performance issues like a pro to make your application fly.
-
Laravel Octane 03: Concurrency and Asynchronous Workflows with Swoole
Explore the power of concurrency and asynchronous workflows in Laravel Octane with Swoole. Learn how to create a high-performance application that handles multiple tasks simultaneously, improving responsiveness and performance.
-
Laravel Octane 01: Unlocking Supersonic Speed: An Introduction to Swoole
A beginner-friendly guide to understanding Laravel Octane and Swoole, focusing on practical performance improvements for your Laravel applications.