Best Perplexity prompts for Computer Programmers

Given a MySQL database with 100 million rows in a single table, and a query that currently takes 10 seconds to execute, use a combination of indexing, caching, and query rewriting to reduce the execution time to under 1 second, providing a step-by-step breakdown of the changes made and the resulting performance metrics.

A Java application is experiencing intermittent crashes due to a deadlock between two threads, one responsible for processing incoming network requests and the other for updating a shared data structure, use a combination of stack traces, thread dumps, and code reviews to identify the root cause of the issue and provide a patched version of the code that resolves the deadlock.

Given a monolithic application with 10 distinct features, each with its own database and API endpoint, design a microservices architecture that scales horizontally, using a combination of Docker, Kubernetes, and API gateways, provide a detailed diagram of the resulting architecture and a step-by-step guide to deploying and managing the services.

A critical production issue occurred at 3am resulting in 2 hours of downtime, use a combination of log analysis, system metrics, and code reviews to identify the root cause of the issue, provide a step-by-step breakdown of the analysis process, and recommend preventative measures to avoid similar issues in the future, including code changes, monitoring enhancements, and incident response procedures.