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#
Community Center | Not monitored
{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.