Need inputs on Web Application development

Question

I need some inputs on tech stack for building/hosting a web application. I'm using Angular with Django as backend and hosted in Azure App Service. I'm using few SQL queries in Django and displaying results in UI. While I'm querying large datasets from Django, its not getting processed. Getting timeout issues and exiting out of API request. How to achieve this, will scaling up Django deployed App Service resolve this? Or if need to change the tech stack for backend, please do suggest the technology I need to use whether it is from Azure or any other technology . Thanks in advance.

Answer 1

@prashanth ganna To add to the great answer from Lex Li, Scaling up the Django deployed App Service might help resolve the issue, but it may not be the most efficient solution. You can also consider using Azure Static Web Apps, which is a modern web app service that offers a streamlined full-stack development experience for building and deploying static web apps. It provides built-in features such as authentication, serverless APIs, and automatic builds and deploys from GitHub or Azure DevOps. If you still want to use Django as the back end, you can consider using Azure Database for PostgreSQL or Azure SQL Database to store and manage your data. These databases are designed to handle large datasets and can scale up or down based on your needs. You may also consider using Azure Functions to process large datasets asynchronously and avoid timeout issues.

Answer 2

How large are those queries? Web apps need to respond quickly to browsers, so the common way is to break down large queries that require very long time to finish into small chunks. Accordingly, people use pagination in Angular.

There are many useful resources showing you how to, such as https://www.linkedin.com/learning/building-angular-and-django-apps/pagination-with-django?u=2270706