Best Perplexity prompts for Software Developers

Given a MySQL database with 100 million records, a query that joins three tables, and a requirement to reduce the latency by 50%, provide a step-by-step plan to optimize the query, including indexing strategies, query rewriting, and caching mechanisms, and explain how to implement and test each step, assuming the database schema is provided as input.

Design a scalable microservices architecture for an e-commerce application with 1 million concurrent users, using a combination of AWS services such as EC2, RDS, and Elasticsearch, and provide a detailed description of each service, including configuration, scaling, and monitoring, and explain how to implement service discovery, load balancing, and circuit breakers, assuming a budget of $10,000 per month.

Given a production incident where a critical service became unresponsive due to a deadlock, provide a step-by-step plan to conduct a root cause analysis, including data collection, log analysis, and code review, and explain how to identify the root cause, develop a fix, and implement preventive measures, assuming the incident report and relevant logs are provided as input.

Design and implement a continuous integration and continuous deployment (CI/CD) pipeline using Git, Jenkins, and Docker, for a Java-based application with automated testing, code analysis, and deployment to a Kubernetes cluster, and provide a detailed description of each stage, including build, test, and deployment, and explain how to integrate with Jira for issue tracking and monitoring, assuming a team of 5 developers and a deployment frequency of 5 times per day.