Slow Application Load in Visual Studio with AWS MySQL Database

swati 0 Reputation points
2025-01-14T11:04:54.0533333+00:00

Description:

I’m experiencing slow application loading times while running my ASP.NET Core application locally in Visual Studio. However, the application performs as expected once deployed to the server. The issue appears to be related to the database connection with an AWS-hosted MySQL (RDS instance).

Issue Details:

When running the application locally in Debug Mode (Visual Studio):

  • Initial load time is significantly slower compared to the deployed server.
  • The application uses a MySQL database hosted on AWS RDS.

Once deployed, the application’s performance is fast and works as expected.

Tech Stack:

  • Development Environment: Visual Studio 2022 (Windows 10)
  • Backend: .NET 7.0
  • Database: MySQL 8.0 (AWS RDS), managed via MySQL Workbench
  • ORM: Entity Framework Core 7.0
  • Frontend: JavaScript/jQuery (AJAX operations)
  • Primary Language: C#
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
41,835 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.