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#
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,343 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
880 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
40,969 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.