How do you diagnose performance bottlenecks in Laravel?
I use a combination of MySQL/PostgreSQL slow query logs, EXPLAIN query plans, Laravel Debugbar / Telescope in staging, and APM tools to pinpoint exact bottlenecks in code, database queries, and server configuration.
Can database indexes be added without taking down the site?
Yes. Using online DDL operations in modern MySQL and `CREATE INDEX CONCURRENTLY` in PostgreSQL, indexes can be added without locking tables or interrupting active users.
What kind of latency improvements can typically be achieved?
By eliminating N+1 queries, adding targeted composite indexes, and implementing Redis caching, slow endpoints taking 1,500ms+ can frequently be brought down to under 100ms.
Do you also optimize server and PHP configurations?
Yes. I optimize PHP-FPM process management, OPcache memory and JIT settings, Redis connection pooling, and web server configurations (Nginx/Cloudflare) alongside application code.